This may have been true in the past, but the Flood Rating 2.0 which they did a couple of years ago dramatically increased the premiums for flood insurance in high-risk areas. We specifically sold our old house as our flood insurance was going from 2k a year to 18k a year. Insurance rate increases were capped at 18% increase per year until reaching the full amount. So high-risk areas either need to shore up or find a sucker to take it off your hands. I'm not saying some people don't find a way around it, but it's not nearly the terrible program for taxpayers that it used to be.
It's never been a terrible program for taxpayers in the grand scheme of things. There were things that needed to be cleaned up, particularly for some repeat loss properties, but since its establishment in 1968, its lost basically $395M per year. Not great, but basically a pittance in the scheme of the national government. And that accounting ignores that the NFIP has never invested surplus funds like a real insurance company would do.
If you look just since 2005, when it started consistently running deficits, it's cost taxpayers about $1.13B a year. Again, not great, but that's about 4.5% of the cost of farm subsidies each year ($25B).
Another way to put that into perspective is that you if you had $23B, you could pay off the cumulative shortfall the NFIP has incurred in total since 1968, but you couldn't make Mississippi's PERS system fully funded.