So yes, the average unemployed American watching the grass grow is doing something more productive.
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.
Would T.J. Watson have had the motivation to found IBM had he not been fired from NCR and indicted by the government for blatant anti-trust schemes? Would Bill Hewlett and Dave Packard have founded HP if it hadn't been the midst of the Great Depression with few jobs to be found? How about Steve Jobs and Steve Wozniak - HP nearly killed Apple Computer in the cradle, because Woz didn't want to leave his employer.
The opportunity cost of employment isn't just a bunch of people sitting on their ass. It's a bunch of people sitting on their asses getting increasingly worried about where their next meal is going to come from. Eventually, some of them do something about it. Big risks are usually scary - it often takes some equally scary big shifts in your life to push you into taking them.
The one person you didn't mention that even remotely fits the profile of desperate entrepreneur is Steve Jobs, which you failed to include.
Do you really think the average unemployed American is doing something any more productive than building an unnecessary bridge?
Also, these projects happen anyways, since in the absence of a US-level program to allocate underutilized human capital our representatives fight like hell to get funding for ridiculous projects in their states, for the sole purpose of providing employment. I'd personally prefer if these projects were devised and approved out in the open by a group responsible for their choices, rather than slipped into important budget bills at the last minute and rammed through Congress because nobody can do anything about it.