I believe San Diego would withstand a direct major earthquake pretty well. Tijuana would probably not fare so well, but, assuming most of our infrastructure stays intact, the rebuilding there could result in a net positive effect for real estate in the county of San Diego. I don’t mean to sound flippant about this, if that’s the way it comes across.
We are more vulnerable to a major earthquake in the Sacramento region, as this could damage the fragile levee system that provides water to about 2/3’s the state’s population. And a major earthquake is far more likely to occur in the Delta region than in San Diego. This would nearly certainly damage the economy of Southern California, and housing prices, severely for at least a few years.