All civil engineering projects are failures until people forget what it cost to build them and just start taking the infrastructure for granted. Eleven people died constructing the Golden Gate Bridge, 96 for the Hoover dam, thousands for the Panama Canal. Do we remember them, or think that these projects were failures for killing people? No. We just think of how convenient they are.

I grew up contemporaneous with the Big Dig in Boston. People called that a massive failure too, even though it only killed one person instead of thousands. 15 years after completion, it’s a big success.

For the golden gate bridge, that's not a particularly large impact of deaths. Even if you don't like assigning a monetary value to lives, bad infrastructure causes its own deaths in the people using it. But it's simpler to say lives are worth ten million dollars and then calculate that those deaths were about 4% of the cost.

For the other two, the death toll was much more significant.

When a wikipedia page has a whole section dedicated to how massive of a issue construction was then it's result may still be good even if the project was a big failure

I doubt it. People were literally gaslighting people into thinking the Big Dig was a good deal for the money as the roof panels were falling on cars. This will be a "failure" for 20yr, tops.