I wouldn’t count somewhere I don’t want to live being cheaper as the prices of all other homes falling… ;) Nor as lack of need to stay either - if real estate prices were the only thing keeping people around, cities might not exist.
I mean yes it’s a bet, but real estate in SF has historically done very well. The progressives/NIMBYs have a strong presence to thwart new housing so that existing properties increase in value.