I haven't been there since, well, last century, but when I was there I did have a good time. My first girlfriend ever was from San Anselmo. I stayed in a crackhead part of the city with her for 1 night. We of course went to Haight/Ashbury, because thats the most important thing you should do if you were me. Went to the the Amoeba Records there. It was weird seeing the homeless hippie kids begging for money on the street, trying to save up to buy some ecstasy or whatever.
I did go to a rave in Oakland. The original venue was cancelled and in its place you were supposed to call a phone number (this was pre-cell phones mind you) to find out where the new venue was (in this case, Oakland). My girlfriend's parents nearly threw a fit when they found out we were - gasp - going to Oakland for a - double-gasp - RAVE. But we ended up having a good, clean time!
The place was still raided by cops a few hours in, but they didn't shut it down. Just checked a few peoples' pupils for dilation - not ours. Not that it mattered because it was an acid drum n bass party and they didn't even have E. So we were sober. LOL.
Anyway, probably the most enchanting part of it was driving over the Golden State Bridge... Now that's a trip. Don't even need drugs to enjoy it.
Also anyway, go Niners! LOL.