My problem with TNG was that they made up stupid technobabble to solve every problem. "I reconfigured the main deflector dish to emit a pulse of deus ex machina particles and that solved the problem" over and over and over. So you discount that and you are left with a little morality play where Starfleet shows that they are better people than the ones they are helping. Cool, lots of people love it the best of all Star Trek. I'm just an old fashioned sixties-Trek kinda guy, where you talked your enemies into committing suicide rather than bombarding them with non-lethal mystery particles that cause them to peaceably resolve their disagreements.
And every problem was fixed with “inverse polarity”
That’s why the remake of Battlestar Galactica was so damn cool, IMHO. The ship operated like an aircraft carrier. Things broke. Things wore out. The people were personally flawed and sometimes it affected their missions.