sdr: Palace of Fine Arts and Exploratorium. We hit the Bay Area for a Thanksgiving family trip every year and the kids loved the Exploratorium (till they were about 11 and then no mas).
Muir Overlook is a flat out amazing view of some of the most beautiful scenery in NorCal.