I am from SF and I still come down almost twice a year because of family. If you are flying in to SFO I would suggest staying in the Union Square area. There are lots of great restaurants, shopping and just sightseeing there. Then, if you are going to Napa, which is less than an hour from SF, just rent a car and drive there. There are tour bus that leaves from the Union Square area, if you are trying to drinking a lot, but if not, driving is better. When you get on the wine track, so many wineries every corner. Back in SF, go to the Marina section and you will love it. Some shopping and great restaurants too. Of course, go to Northbeach for some italian cuisine and right next to it is Chinatown for some souvenirs. Then go in SOMA in Embarcadero for sightseeing and on Thursday/Saturday they have Farmers Market. SOO Much to write, but you can always ask your concierge too for other spot. Have fun!