We moved to Houston in 2020. The impact of flooding from Hurricane Harvey had not yet been incorporated into floodplain maps, but was readily available as its own dataset. We used that map as much as the map to navigate us driving to houses we looked at. We could also see flood impact in the price of houses, with some houses, which had been flooded, 1/2 the price of others across the street.
Harvey was bad, but by no means was it the worst possible flooding imagainable--some kind of boundary by God of what could happen. So while we shopped smart, and although our house has the lowest level 1 risk from FEMA, we sure as heck have flood insurance.
When we were in Michigan, we used to live on the 3rd highest hill in the county. In the winter, we could see the lights from four nearby ski hills, and on the 4th of July we had a panorama of fireworks. There, I used to joke that if we needed flood insurance, most of the county needed submarines. But even in mountains, if you are by a water feature, you need to consider what happens if it goes over capacity.