Not in our lifetimes. Any American not retired or who doesn’t own a home most likely wants to move to the Bay Area, and most likely because there are jobs. The only reason they don’t is the rent rates.
Housing by market value is a losing proposition.