So downtown San Fran is one of the worst big city downtown's I've been too. Not impressed at all.
I played hooky yesterday, rented a car and went across the bridge. That's where things got significantly better! I pretty much hit most of the places that were listed in the article I linked to above. I'll post some pics when I get home.