This is going to snowball affordability issues and environmental destruction due to the new demand.
Just look at North Carolina. A few years ago, random people insisted the Asheville area was a climate haven. Affordability was thrown out the window, countless trees cut for new builds for the new residents, then Helene hit and shattered the haven narrative. The same thing has happened throughout NC though. Rampant farmland and wooded land developed for more people to move here, because they think it'll be safer here than Florida.
My prediction is the sleeper communities in the "decent zones" will grow and become new midsized cities as people move there and businesses follow.