Controversial opinions? Okay.
TNG is vastly overrated.
The Borg were drab and uninteresting prior to their soft reboot as cyborg zombies in First Contact. The Borg Queen gave the Borg much-needed personality.
Trek is at its best when it involves morality plays, character studies, and interpersonal conflict. Trek is at its worst when it leans into technobabble and makes clumsy attempts at hard sci-fi.
As for the Borg, I am conflicted. Seen purely as a threat, a menace, I think they were far more chilling in BOBW. A faceless force of the collective you couldn't reason with, that didn't even
understand why species would resist assimilation. An opponent that not only didn't agree with concepts such as death, resistance, or self-determination, but basically didn't even recognise such concepts. However, the number of stories you can tell with such a foe is really limited, and in that sense I can understand that if they wanted to keep using them in the future (e.g. in FC) they had to give Picard 'someone' to play against (the Queen), even though that fundamentally altered the concept of the Borg.
I agree that Trek is not hard sci-fi. As for technobabble, I think there's
good and
bad technobabble.
Good technobabble never becomes a major point of the story, but simply conveys the impression we're dealing with trained specialists here who really know their stuff (and sometimes will communicate in specialist language simply because it's far more efficient).
Bad technobabble is used to occlude that the scriptwriters don't know or want to envisage a solution either, and simply say: 'look they're solving the problem with something really technical and sciency, ok? But we can't be bothered by thinking up something actually clever so we'll just say flooding the anomaly with techbabblion particles will make it disappear!'