I completely agree with you if we believe whatever currency your loan is in will remain relatively strong over the next 30 years.
At this point, I believe it hinges much less on real estate appreciation and much more on ever growing currency debasement. Imagine taking a 30 year 5% fixed rate mortgage on a 1 million USD house in Turkey 7 years ago. That was only 2.7 million lira at the time. With a monthly payment of 15k lira ($5,300 USD 7 years ago), that's currently only $1500 USD. In a few more years time, that will be even less monetary value.
I don't know if you live in a place like turkey but on a long enough timeline, every fiat currency will follow the same trajectory. So the longer the payback period, the more likely you can pay it back with cheaper and cheaper fiat currency units
