I love SF, it is my favorite city. Husband was stationed on Mare Island in Vellajo back in '83-85. If I had to live in California I would want to live in the Bay area. It has so much to offer.
Have a great time. It is great you have family there, that will be helpful.