Pipe in Sarah MacLachlan music?
Most of the other 100 most populous cities will not and cannot enact policies like San Francisco, so what you're talking about is Fantasyland stuff. Millions of people see what's going on there with codification of the sorts of sentiments and dogma I write about all the time with regards to contemporary Leftism. It's a disaster. Even here in liberal Madison, we've had a large segment of the population that's had enough of not being able to walk around downtown, by the capitol, without almost stumbling over homeless people sleeping and begging. Our 1960s radical mayor was made into a reactionary right-winger when he proposed an area somewhere else where the homeless could set up camp. It's crazy. Of course people in cities that aren't leftist bastions are going to want no part of the sorts of policies that result in these situations.
I don't know what the solution is, but I do know that doing the sorts of things that these places do: not enforcing vagrancy, public exposure, littering, needle exchange programs, drug laws, et cetera, are a recipe for disaster for anyone who values a quality of life for the entire polis. Then again, if you can live behind a gate or wall in these communities, perhaps you just have to care about your own insular world that the homeless will never invade?
Of course there's a connection between "progressive" policies and situations like these.