Example that gets almost everyone: Space Shuttle.
It was supposed to be reusable space truck that reduces cost. It was several times more expensive than conventional approach with non-reusable rockets and shuttle. It was infrequently used. It drained NASA budged from anything productive. Even those combined manned+cargo missions could have been achieved cheaper with double launch. It was objectively failure based on the goals and purpose of the project.
They developed so much new technology and inspired people. It was simply great piece of engineering and PR. We learned a lot.
I wonder if there were missions that would not be possible without it (maybe the Hubble launch and the AMS launch and installation) though most likely they would be adapted to work without it.
Yeah, maybe they could be a double launch or worked in some other way.
So, I agree with you. It is a waste. It is a waste of human hours that was spent with nothing to show in return.
Building a bridge that collapses minutes after construction also entails workers earning salaries, and perhaps learning something. that still doesn't mean it's a good use of funds, it's waste. you want the investment to create actual value for someone.