People in the neighborhoods with fewer problems (let’s face it, there are many very quiet expensive neighborhoods in the Bay Area) have very “progressive” views on the homelessnesses. They don’t experience its effects frequently, so don’t think it’s a big problem. They vote for policies that grow social services for the homeless, even though those policies don’t work. But the idea they have is that these services just need more money. And then more money again, and again.
Progressives live in cities more than anywhere else, San Francisco being a center of progressivism. The critics live elsewhere, and love to tell people in cities what they really should want and do (more guns, no progressive reforms, etc. etc.). In NY, the anti-progressive vote was in the suburbs; in the city they do well. In Philadelphia, the progressive DA did best in African-American neighborhoods.