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!