Homes don't generate value though. Nothing more is being created by them existing. How can it possibly be an investment generating more wealth when the underlying asset remains unchanged?

It's just a pyramid scheme to expect the same exact home to continue going up in value as an investment. The only possible result is a shortage of housing with unreasonably high prices