The CBO analysis already settled this, New York Times. It is a drag on the economy and the added debt will continue to drag it down as interest continues to accumulate from this - adding more to the red side of the balance sheet for generations.
We did not get back the money that was spent on this as a return on investment - the overwhelming majority of it was not for infrastructure improvements but for junk and to increase the baseline of already existing social programs.
And the whole “had it been larger” - LOL - since it added to the baseline of so many programs it has in fact been implemented multiple times over.