I'm sure the fact that there's an increasing trend of empty Chinese investment properties isn't helping. I grew up in Cupertino, and when I visit my parents there, I'm rather shocked at how downhill the neighborhood has gone in parts. It's crazy that these old 70's tract homes go for 1.5 million. Even more insane is that they're bought and then left empty to go downhill. Literally broken windows and paint falling off…
Transit is abysmal in San Francisco. Muni is an utter disaster.
The fact that it exists doesn't make it "decent." Cities with decent public transportation include Berlin, Munich, Zurich, Moscow, Tokyo, Hong Kong, Taipei, Portland. Even New York is much better. SF is a far cry from any of those.