If that source lags behind reality, or fails to give a picture of future trends, people still get caught unaware.
Isn't this fundamentally the role of insurance? They have the incentive to look forward and anticipate risk, and if flood insurance is particularly expensive or just plain unavailable on a given property, you should look at why.
Is there a generic form like "Give me insurance quotes for every possible type of coverage" that a prospective homebuyer could fill out and submit to a few different insurers, to get a picture of such red flags?