A good city should be able to withstand people moving there. Otherwise it was probably only good for reasons that aren't actually inherently city qualities, such as culture or access to nature or cheap land.
And I'm not sure we'd want it to anyways? When prices get too high for later folks to move, then that's a great signal to actually go elsewhere.
I'm not sure why we'd want a system where everyone just migrated to one or two cities in the entire US. I've seen those cities in Asia that have populations of 15M or 20M and yeah, seems super inefficient once you get to a certain size.