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.
? I didn't ever see anything worth the trip. Not even enough to fill a single afternoon. Could never understand the attraction or mystique. Couldn't wait to head out of the city and up or down the coast. Live 750 miles away (not far enough!).
At Columbus and Broadway, I once encountered a homeless person who implored me to help “an old wino.” I almost gave him some money because of his honesty.