The "investment" should not be "I can sell this in 20 years for a boatload of profit" but rather "I don't have to pay rent when retired, only property taxes + maintenance + energy".
But when property values are wielded as arguments to beat down proposals for growth, for transit, etc, it's clear that this isn't the meaning in use.
Unless you end up getting a reverse mortgage, in which case I guess you were renting all along.
I just put together a spreadsheet assuming 1% maintenance, 1% tax rate, and 3.5% mortgage rate on a 250k house. You still would need a 5% annual rate of return to make money. After 15 years you would have hit your $250k capital gains limit, but you'd only have $70k in profit after taxes, interest and maintenance. At 3%, you lose money until well after the house is paid off.
Further, your mortgage interest up to $750K is also tax deductible, and you have to index the whole thing to inflation. Once you do all that the costs are either nominal or negative on a 3.5% 30 year fixed deducted from a Bay Area income. Until Donny took us for a ride property taxes were deductible too.
This is what it looks like when owners vote.
In California, demand is high, and prices have been inflated by constraining supply due to a lack of upzoning. It also doesn't help that CA has proposition 13, which locks you into your purchase price tax rate in perpetuity. You should see wilshire country club's property tax bill, it's like a couple buttons and pocket lint.
But it also decreases turnover. Say its 1970, you buy a house in LA for 50k, have your kids, they move out, you are old and want a smaller place, it's 2019, and your house is worth 1m but your taxed as if it was worth 50k. You can cash out, but if you want to continue to live in LA in another 1m property, you pay taxes on that 1m.
It's like rent control for homeowners only you can also give your house and that sweet sweet 1970 tax burden to your kids, perpetuating the landed aristocracy at the cost of the working class.
In the modern era, if you don't own a home already you probably couldn't care less about the investment quality of a home. You just want a home to live in and call yours without an 80 minute commute.