My wife and I lived in the Bay Area for a year. It was great - beautiful weather (San Mateo), incredible farmers market, and we met some really cool people.
I'm glad we did it, but I'm also glad that I moved back to Ohio now.
Beyond having my extended family around here, it just feels like a better place to raise a family and be part of a community, whereas SF seemed more geared towards single or childless folks who were very focused on their carriers.
The Bay Area is also incredibly expensive. After moving back, I went to a movie with a friend, asked for two tickets, then tried to correct the attendant because the price was so low that I thought she must have rung me up for a single ticket. That's just one example, but nearly everything costs more in SF.
Oh, and our house in Ohio cost slightly less than my current annual salary - I had an apartment and the mortgage overlapping for a couple of months here, and even paying both was less than what my rent was in San Mateo.