This is why I always cringe at articles that say "Nobody can afford to live there." The reality is that lots of people can "afford" to pay these prices, more than there are homes, hence the high prices. When people stop being able to afford the houses, or willing to pay high prices, guess what, the prices go down. When I bought my current home it was during one of the "downturns" when everyone said "Silicon Valley is dead, look at all the chip companies laying off people and going out of business!" And then the Internet became the new thing and the market rebounded. And then it crashed again and house prices went down, and then it rebounded again.
Houses cost what people are willing to pay for them. And when people stop paying what is being asked, the price goes down. Speculation can hide some of that dynamic during periods of rapid price increases but a lot of speculators go broke and give up. We saw a lot of that during the mortgage meltdown.
I think it is great that the prices have moderated. And I think the number of new housing units coming on line has helped that as well.