> housing cannot be both a good investment and affordable

Yes it can, if you let people invest into development projects at the venture stage. (This carries inherent risk, of course, but not as much as you think.)