Hotels in San Francisco

Thought I would venture to the verge forums to see if you fine people have any tips for accommodation in San Francisco. Any good bars/restaurants/stores that are worth visiting but do not tend to show up in guide books also appreciated...