My wife and I traveled to SF about 8 years ago and we 
loved it.  Even if you're only remotely interested in wine, I think the drive to Napa is worth it.  Alcatraz was a cool site to visit, and I remember driving down Lombard Street just to say I did it.  
 
The GG Bridge wasn't anything special IMHO.  I live near three major, long bridges that take me into either PA or DE so I may be jaded.  To me it was just a bridge painted a different color.  

  Maybe I didn't catch it on a good day....no fog.  
 
My wife and I drove up from San Luis Obispo via Route 1.  The scenery was fantastic.  If you don't mind longer drives, a trip to 17 mile drive may be worth it.  After we did 17 mile drive we jumped over to the major interstate, so I don't know what the scenery is like on Route 1 north of it.  From what I've heard, it's not as dramatic, but I dunno.
My favorite CONUS trip to date.  You'll love it!