Housing cannot be both 1) "a good investment" in that it grows more than the economy 2) and affordable.

Ideally, prices would be fairly stable, so that people can swap out of different housing depending on their needs at different stages of life without stressing too much about 'the market'.