I was there a few days only, and I know very little about SF. But I recommend going to Haight-Asbury St. (think I spelled that right) and also Pier 39. The Crab House has amazing food and the best beer I've had in the continental US.
You also have to see postcard row and take a pic there.
Now maybe the locals can offer some non-hokey stuff.