Fisherman's Wharf isn't for me. I would definitely recommend union square or the Embarcadero district. The Embarcadero area is not as 'happening' but there are some very nice hotels in the area (and cheap if you use Priceline). Union Square has a lot of great hotels in the district, and it is close to Market Street (SF's main street).