I'm thinking of going on a last minute vacation in San Francisco—probably mid-August. Is that foolish?

Recommendations for places to go, things to see? (I'm not a big outdoorsperson).