A useless bridge will be a drain on the budget in subsequent years for little economic payoff in terms of improved productivity. It's an extremely inefficient allocation of resources, to the point that it's very likely that it's worse than almost all alternatives that don't involve building something.
Look, just read a textbook or two on macroeconomics. This isn't a new idea. You're just uninformed, sorry.
There are just always better things to do with that money than making something useless. There are lots of projects that could actually make business more efficient and attractive to conduct in the US.
But failing finding something useful to do with it, they could produce nothing and we'd still be better off. What you're talking about with building a useless bridge is a terribly inefficient form of welfare.
Think about it this way: By having those bridge builders watch the grass grow and sending them the money you would have paid them as welfare, sending the suppliers the money you would have paid them, you get the trickle-down effects you mentioned without the future cost obligations that come with actually producing a bridge to the middle of a lake.
So my original point stands. It's worse to produce something completely useless than it is to not produce anything at all.