I also invest to make money but I will not invest in something I can’t stand for. I used to have most in S&P 500 but moved it out because I will not invest in Tesla or Amazon.
I have no idea about the situation in the US but normally prices will always go up because inflation. Sometimes the price will flatline or go down for a bit because of lower interest rate on a loan but the also more people want to buy. More buyers == higher prices.
Some time ago I heard a story about a couple buying a house in the 80s in a big city for an extreme high price. Now that house is worth 20x more than it used to be.
But then again, I have no idea about the situation in your country. In my country even the cheapest houses are made to last at least 80 years.
Would be interested in a list of past facts that turned out to be wrong.