"Housing is an investment" is just a sales tactic that took over and went insane.
It's only really used to justify the humungous loan payments you're willing to take on.
I'd happily take a $1 house if it was guaranteed to never change in value; but it also served my needs.
It's moderately fun to try to figure out what a "healthy" home market would look like - probably something similar to cars; "used" houses should sell for significantly and noticeably less than "new" ones (all things considered). But location and constraints often invert this - the new houses are so far away that they sell for less than the old ones in more favorable locations.
The scary thing is that ONCE you are metrically fuckton in debt, you become exceptionally concerned with the valuations, because once it trends to level or goes under, you're stuck!