This is actually an interesting discussion because whether or not it was worth it depends on how many tiers of "big picture" you're thinking.
For military nerds it was a US win. Majority of actual engagements were US victories.
But if we zoom out and look a little bit more big picture... it was a massive US loss: The political aim was to unite vietnam under western style democracy and win it for the south. The exact oppossite happenned = loss.
But let's zoom out even more: The vietnam war has to be seen as just one part of the cold war. Why was the west even involved to begin with?
-To stop the Domino effect in southeast asia and prevent communist dominance of pacific shipping chokepoints
-To demonstrate to russia that if they get involved in asia, we'll be there to block them
Both of those goals actually were accomplished... the US held off communism long enough for democratic forces to win in Thailand, Malaysia, indonesia, and the phillippines, all the most important dominos. This Meant there was no longer a fear of communism dominating that region of shipping chokepoints. Russia also backed off on trying to fuck around in the region when they realized it wasn't going to be free real estate.
People who say "the vietnam war was completely pointless" are operating on a very narrow lense. Everything that happened in those 40 years has to be seen as part of a much bigger picture.