We live in the SF Bay Area. We moved here about a year and a half ago, because my husband's company was acquired. I didn't want to leave our old state (Colorado), so I certainly didn't come with a rosy vision of California.
That said, I'm really impressed with the opportunities for homeschooling. It is easy to homeschool, and there are a lot of class opportunities for homeschooled kids -- everything from weekly classes at the science museum, out-of-the-box math classes, co-ops, language immersion classes, nature awareness classes, you name it.... The local museums offer free days for homeschoolers. Mass transit is excellent. I much prefer the weather here to the weather in DC.
If your husband is in the city, it may be worth considering living on the peninsula, if it is in your budget. We are mid-peninsula, and it is really lovely here. You are not far from the beach, but you don't get the fog. The summers are mild and heavenly. It never gets too hot or too cold. There are a fair number of homeschool groups, especially as you get closer to the Mid-Peninsula and South Bay. The school districts here are very good (all of our zoned schools at our house get a 10 rating on greatschools.com), and there is SO MUCH culture available in the city. :) My husband bike and/or train commutes, and it is not bad at all. :)