If a City implements a solid transportation system that gets you in the burbs within an hour, then the prices drop. Prices are simply a matter of demand and supply, and supply is artificially capped.
The truth is, humans are terrible long term decision makers for the good of a large population. Personal agendas always get in the way.
Seattle's real estate market has some but not all of the same pressures: too prescriptive of zoning that requires single family homes for no good reason and booming economies adding jobs at a faster rate than housing stock. But Seattle builds faster and taller in the median case; though the tall building seems to go through waves of either being all apartments or all condos.
Seattle has built enough housing supply that rents actually dropped earlier this year (https://www.seattletimes.com/business/real-estate/seattle-ar...) and the median clearing price is less than half of the San Francisco rate.
With the current supply problem in Bay Area, realistically all you are going to get is marginally more displacement of people who anchored themselves to a super expensive area in the past, but could not sustain a 10x increase in tax.
Building enough supply can work: https://la.curbed.com/2018/5/2/17311992/los-angeles-how-much...
And it doesn’t take long for things to stabilize either, once you increase supply.