You’re essentially talking about decommodification of housing, which is the only correct answer. It is necessarily impossible for a house to be both affordable and a good investment, and the current status quo means that housing will be used as an investment. Whatever mechanism used to fix the housing affordability problem will require that housing no longer be subject to commodity market forces.