Housing can't be both affordable and a good investment.
Look at Japan, for example, where houses lose their value after 40 years. I pay cheaper rent in Tokyo than I ever did in even mid-sized American cities.
The housing market boggles my mind how houses don’t appreciate at all there.