I think the problem with SF is not that it isn't a utopia — it would be unfair to expect that of any city — it's that it's worse than nearly every other in the US, especially for those in the middle class and lower class.

You might argue, "well so many people continue to live here and love it" — and that's true...except most of the people that happily live in SF are rich tech workers that are comfortably in the top quintile of the income distribution.

The tech worker might love SF, and indeed it might even be a beautiful city — but what of the teacher, police officer, firefighter, janitor, and waiter? Is SF really the beacon of progressivism it claims to be if it's (quite possibly) the only city in the US where a teacher can't afford to live within a 30 minute commute of their school without roommates?