At a California Republican state convention, I met a Chinese-American who lived in The City, as Northern Californians call SF. He said that living there was like living in an insane asylum.
When I'm in town, I usually pick up a loaf of sourdough Boudin bread and eat ravioli at the Cafferata on Columbus and Filbert, but I'm not sure I would want to live there.
Yes, awesome tourist city. You need to stay 2 weeks to see and do everything. Just the liberal/opportunistic mentality of the residents make living hell for everyone, and if you are conservative it is 3x worse.
Even going back for a visit I get constant reminders. I get off a ramp and there are druggie/alchie bums panhandling. I cross a street and their is a poster for some gay sex website. I drive down a street, and there is a crowd of critical mass bicyclists blocking traffic. Here a gay parade. There an anti-war protest. Nuclear free zone. Save the whales. COEXIST bumper stickers everywhere. On and on without end.
But as a tourist city it is hard to beat, and everyone should make an extended visit at least once or twice in their lives. It is a beautiful city with a lot to do.