The CityNerd, Ray Delahanty, just published a video on this topic.
https://www.youtube.com/watch?v=Fcn77OwF9XE
(You can safely increase the speed of the video to 1.5x. He speaks slowly.)
If you don't feel like watching the entire video, I'll just recommend Iowa City, Iowa. It ticks all your boxes except maybe climate change refuge. But with all the money you save on housing, you can buy a vacation cabin/bunker further north.
If you don't feel like watching the entire video, I'll just recommend Iowa City, Iowa. It ticks all your boxes except maybe climate change refuge. But with all the money you save on housing, you can buy a vacation cabin/bunker further north.