Jeff Masters at Yale Climate Connections has an article with a massive list of articles, books and tools on climate risks in various geographic areas of the U.S. You could really spend a lot of time drilling down through all these sources, even to research just one location. He does make the point, however, that moving away from extended family and other social ties can be bad for a person/family’s resilience in general, so you should consider that tradeoff before deciding whether to move.