I've been here 10+ years. SV is about people and activities rather than touristy sights. It's things like Friday night bike party in SJ, midnight roller-skating in SF (first time for me was pure adrenalin-pumping, flying down the hills around Union Square with full traffic and barely know how to brake!). Bay-to-Breakers "race :) ". Inventor Fair. 9:20 Special Swing Lindy dance club (just watching the dancers is breath-taking in itself). Hiking up Mission Peak in Milpitas or Rancho San Antonio, Cupertino for some righteous views of the Bay.
Yeah, this place is about doing things, I guess.