At it's heart it is an attempt by someone who makes their living selling a thing (real estate) to instill a since of FOMO in order to motivate you to buy something now rather than perhaps later. You can't really fault them, it does tend to work.
I happen to live in the "red hot" Bay Area and twice wince I've been living in my house its value has gone DOWN year over year rather than up. I have never considered it an "investment", rather it is a fixed cost that I have to pay to live indoors. My parents live in Las Vegas, and that housing market, which has been largely unconstrained, demonstrated exactly what that means. Houses in Vegas for a long time depreciated after you bought them, just like cars. They did that because there was so much new housing being built that you could buy a "new" house for the same price as a "used" house. Guess what, people opted for "new" and used houses needed to sell at a discount if they wanted to sell.
One of the truisms for years was the value of a house was intimately tied to its location. This because it was close to jobs, or schools or what not. It is my hope that remote work really takes hold and you can work just as reasonably in a $100,000 house in Missouri as you can in a million dollar house in the Bay Area. That would really create some downward pressure on prices because of simple market dynamics.