Climate change will drive a lot of people to the northeast and Midwest in our lifetimes. Much of the Deep South will become unlivably hot and humid, and much of the west will become dry enough that water rationing makes life in the sun not so much fun anymore.
If you want to invest, put your money in places like Pittsburgh and Buffalo. Some values along the coast in Baltimore and Philly too. Plenty of cheap real estate out and I suspect we’ll see a revitalization of the rust belt as climate change makes other areas untenable.
Larger cities, especially those in warmer regions, is a very good bet.