In particular, New York City establishments said people who came in from the suburbs and brought money in would stop coming in.
The ban was successful. A year or two later Hoboken passed a ban because people were increasingly going into the city for the cleaner indoor air they couldn't get in Hoboken.
As a New Yorker of over two decades, I'd love to see such a ban here, perhaps with some areas, like Times Square, zoned to allow it. As with smoking, I expect a large majority would support it once implemented.
However, it is the purview of government to legislate things like this to establish protection of the "commons".
No it doesn't. Architecture, etc, does that.
More to the point, cities are where people live, not works of art. Seeing all the advertisements in Manhattan might be fun for tourists, but they're straining for people who live there.