OP, you could probably do a lot of the research yourself with the Internet. I’m assuming you expect to work remotely forever.
r/samegrassbutgreener has a lot of discussion on this topic
How warm will the city be in the future?
https://www.vox.com/a/weather-climate-change-us-cities-global-warming
Where is drought likely?
https://www.ncbi.nlm.nih.gov/pmc/articles/PMC4644081/
How far is that city above sea level?
https://whatismyelevation.com/
Best small cities lists ( these are like cockroaches. They proliferate. If you’re looking for big cities, small towns, etc. those lists exist, too.)
https://www.fiftygrande.com/guide/coolest-small-city-in-every-state/
Best state colleges ( again many lists with different opinions, but it’s hard to beat CA and VA college systems, which is why we ultimately stayed in VA)
https://freopp.org/ranking-the-50-state-public-university-systems-on-prices-outcomes-3d807df8121d