Exactly. People want smaller government until it is their project that needs to be funded. One can argue whether government, private sector, or some combination of the two is most efficient at completing these projects. But without government being involved in some way, most of these projects don't get done. And at some point, one can argue that the cost outweighs the benefit, but it kind of stinks when it is your home that is being considered not worth saving.
I did some infrastructure financing not too long ago and was largely on the periphery of it, but saw enough to be dangerous. I was involved in the early stages of a massive project to alleviate major flooding issues in the Fargo area. It involved a ton of coordination among the Feds (Army Corps of Engineers), multiple states, counties, cities, public-private partnerships, etc. People had to move out of their homes. Farms were taken over. And the debate is do you plan for the 100 year flood, 500 year flood, etc. And there are those (who generally did not live in Fargo) who asked whether it was worth spending all this money to save Fargo. I haven't checked in a while (this was about eight years ago) but I'm assuming much work has been done on it.
The irony is that they have more water than they know what to do with (as do many other areas) while Southern California and other areas don't have enough.
And yes, I got to go to Fargo TWICE for this project. One right after Thanksgiving (when it was unseasonably warm and raining) and once in June when it was lovely.