As far as gastronome, San Francisco cannot be beaten. You could spend a whole weekend eating your way through all the amazing restaurants in the Ferry Building…my favorite is the Slanted Door. http://www.slanteddoor.com/
On the weekends there is also a great farmers market outside on the ferry plaza…a lovely setting with all sorts of sensory overload !