My experience has been that people who are more comfortably well off than I am are not really looking very closely at the details of homes when they survey the lower end homes. I have had conversations with people who claim there is tons of affordable housing and they pull up some low priced listing in Detroit, a city in such a state of crisis that a woman created a non profit to pay water bills there. I have looked at listings in Detroit. The dirt cheap listings I looked at while homeless were mostly a case of "Oh, god, no! I would rather keep sleeping in a tent!" I am talking about burned out husks or houses that had been flooded and now had horrifying mold problems.
Things I was looking for in a house as someone in genuine need of affordable housing:
In walking distance of basics like a grocery store or, at minimum, able to get to such cheaply and efficiently via public transit.
I want something at $100k or less that can qualify for financing. When you look at a lot of super cheap housing, it is cash only and has defects that disqualify it from any kind of bank financing. I have seen houses listed that explicitly said "No foundation. Will not qualify for financing."
A single family detached house that is not a trailer where the price includes both house and land. When buying a trailer you are frequently buying only the trailer, not the land it sits on, and it is located in a trailer court where you have additional rental fees for being on that land on top of the purchase price of the trailer.
I want a modest home in decent shape. I don't mind a fixer, but a lot of cheap housing in the US has major defects that will cost serious money to remedy. It is a sucker's deal. You should not buy a house like that because budget matters. You buy a house like that because it has amazing views or historic significance or something and you have deep pockets. Poor people buying that kind of house are getting stiffed.
I basically want the kind of house I grew up in, something that affords one a lower middle class life with security and financial stability and a future. And it is extremely challenging to find that anywhere in the US. I concluded it does not exist in California. A lot of lower end housing is trailers and condos and stuff being sold as a tear down because it survived a fire.
So the next time you survey local real estate, maybe consider looking a little more closely at the details. Because your opinion that this is not really a problem in California flies in the face of countless articles about the affordable housing crisis in the state that routinely make the front page of HN. There is lots of homelessness there and people getting roommates to be able to afford a place at all. And I have difficulty fathoming how you can so cavalierly ignore the overwhelming evidence and pronounce this not really a problem.
I wanted to be an urban planner before life got in the way. I have formal education and have done a lot of reading related to this. It is not an uninformed opinion.
Modest is $150K to $200K for a home. I get there this way; At a salary of $48,000 / year (take home $38,753) and allocating a bit less than a third of the take home to paying the mortgage that is about $1K/month or, at current interest rates a $150K - $200K house. $48K/year is about 60% of the median salary in California.
As far as checking out the scene I look at things like how many days on the market for properties that are for sale, infrastructure (markets, transportation, nominal weather, services, crime statistics, Etc) all the kinds of things that I normally would check if I were moving there.