I maintain that the problem is not "we need more housing for all these people!" rather, "we have too many people!"
Why do we have so many people so densely packed? That is the problem we should solve for, not treating the side effects of density. Lower density is what we want, less people in any given square mile.
In other words, we shouldn't be trying to live near major population centers. We shouldn't have to. Our notion of 'work' is/needs to change to reflect that. LA, NY, SF, etc... historically became huge because it needed to be that way. Remote work is becoming more and more common. Regular work is being automated away by software or machines.
I made this argument once before and was totally shot down because I didn't articulate it properly ... but who wants to live in a densely packed apartment complex in the middle of a noisy city? Sure, some people LOVE that, and they should have every right to choose it. But... a lot of people HATE that and are forced to do it, because it's all they can afford. That is the problem that we need to change.