Sd was listed in some study as the 7th least affordable of the 50 largest metros. LA and SF being the worst. That still doesn’t mean the quote from Keynes from a century ago isn’t true today “the market can stay irrational longer than you can stay solvent.”
We saw this with the great recession, SD did not have the 50% declines experienced elsewhere so it probably wont next time either. It pains me to say but brian has a point, if it makes you happy and you can afford it, just sell there and buy where you want.