the worry is misplaced because stupid projects are compensated by good ones. This obsession with efficiency, which seems to be an artifact of modern economic logic is one of the culprits of why nothing gets build. Effectiveness matters, not efficiency. This is just the same logic that VC investors use. nine out of ten startups are crap, some are scams, but it doesn't matter. Better to waste some resources than to build nothing at all.
China understands this. People will laugh at empty ghost cities or wasteful vanity projects but they're compensated for by what works and tacit knowledge generated in the process. America's gilded age or new deal era or cold war military projects were no different. Better to go big and get something done than do nothing at all. And that's usually the two choices.
Your examples are all wrong though, projects with no end goal are not efficient almost by definition.
That said, the nature of most projects is they will only last for a short time without maintenance. How much of what you are accusing of being projects with no end goal with projects with constant ongoing maintenance?
For example, almost nobody knows about Braess' paradox, where adding roads and cause more traffic. This is not induced demand, it's simply worse traffic for the same quantity of traffic through expanded routes.
And there are tons of examples of getting rid of highways where the traffic just disappears, and everybody is happier.
Or, locally, people are advocating against a small commuter rail project, in economic grounds, while the same people are advocating for spending 10x on highway projects that carry about the same number of people.
Blame the politicians, but they are mo stupider than organized groups.
Locally there are a couple of plans to tear up and reroute highways in a decade long project where the highways literally just finished major tear-up-and-reroute project.
There's another nonsensical proposal to tear up one of the busiest highways around and replace it with a nice boulevard because wouldn't that be lovely, except without any plan for what would happen to the rest of traffic.
There are NIMBYs but there are also people worried about projects which are trying to help won't actually make anything better and often will have real negative consequences.