Take a walk down Haight St for the hippy experience. Toronado and Magnolia are along there. Toronado is a hole and if you have a missus she will hate you for it. Good sausages next door, plenty of Belgian beers on tap and soothing heavy metal over the sound system. Minnies across the road has some good BBQ. Further down Magnolia's is full of English beers.
City Beer is worth a look. 21st Amendment is a top place, there's a bar across the road too (Iron Springs maybe).
I stayed on Mission St, it's full of bums, strip bars and smells of weed but I walked around at all times of the night and never even got bothered. Again not woman friendly though.
Definately do Alcatraz. Walk thru China town aswell even if it's just to see how low down the ATM's are. There's Buffalo in the park. The museums in the park were good.
Just north of SF - Lagunitas is a fun place, Santa Rosa is worth a look too, Russian River and 3rd St Alehouse are there. I got absolutely stonkered at RR and I dont like Belgians or wine barrelled aged beers.