That’s not to say there’s nothing of value in your podunk city / town. Just that maybe there is a reason a home costs 100K there (you need to be extremely privileged to make much more than that, there).
People aren’t not coming to your podunk city / town because there aren’t better places to live than New York / San Francisco / Seattle / LA. It’s that the switching costs are extremely high, and once you make the move you can’t easily go back.
So you have to be motivated by something: a deep desire to buy cheap propert, a love for that community, family connections.
I have much better luck moving to any other big global city in the world than to some podunk city / town. That’s just the way it is.