Virginia Beach has these laws. There's signs all over the place saying this.
They are kinda funny.
But in a tourist town like VB, I'm not totally opposed to it as they are trying to create a family friendly environment. But then, I was just there on vacation, and not a resident. I might have a different opinion if I lived there.
There is something to be said for general public decency, maturity if you will. But that argument leads to censorship and first amendment arguments.