If you view homes as consumer goods rather than financial assets, the tension disappears.
It's nice that you would like the world to be this way but it's time to put this tired old canard to bed. It's not individuals but the financial system that treats houses as assets. They do so by extending mortgages. Try getting one for your car.
Yeah, I view my house as a consumer good and I don't want the value of my home to increase relative to inflation - ignoring taxes if I have to sell it I'd just have to buy another house at an increased price which will take up any realized gains from the transaction. Plus the fees involved in the cost of buying/selling are higher now b/c they are usually a percentage of the transaction.
If the value of a house doesn't increase, then the property taxes, upkeep, mortgage interest, and selling fees would make home ownership untenable and worse than renting. And then if you rent the problem gets pushed up to the landlords anyway.