Forget Pier 39 and Fisherman's Wharf. Here's a great article featuring the best of San Fran for locals:

Must-Sees for Locals in San Francisco, California