Much of the housing stock here is old and decrepit.
I don't think it's very smart to pay a lot of money to live in old decrepit houses.
There some really nice areas in the Bay Area. But "Bay Area" has been expanded so much that it's become meaningless to me. I don't consider San Jose the Bay Area. I would call it Silicon Valley.
To me, the Bay Area sucks unless you have the money to enjoy what it's got to offer. For many, the commute is horrendous and the weather is dreadful compared to San Diego. The Bay Area has more glamour than San Diego but only for the well-to-do. San Diego is overall a more pleasant place to live.