One of the interesting things about when I was re-watching TNG in 2019 in the lead-up to PIC was seeing how everything I associate with Berman Trek slowly and gradually crept up over time. It didn't happen all at once. But by the seventh season, everything I didn't like about the Berman Era was there in full-force: the wallpaper music that saps the energy out of everything, the over-reliance on technobabble, the character B-plots that don't really do much, the "everyone knows everyone" feeling, and the forced conflict between the main characters. "See? We can have conflict and arguing too!" which just doesn't work when all the characters are usually so chummy.
I did like the weird, out-there plots they had in seventh season TNG. <<-- Unpopular Opinion
But the issue I had with the weird out-there craziness was that they tried to explain it all away with technobabble. I wish they didn't do that. The crazier something is, the more you're supposed to be able to suspend your disbelief. If you're trying to go out of your way to explain something, or sometimes even over-explain it, then you're telling us we're not supposed to suspend disbelief, which doesn't help anything.
In contrast: I buy into the Spore Drive and the Mycelial Network because they never over-explained everything, didn't get all technobabbly about it, and gave us the space to actually suspend our disbelief. Which is a major point where Berman Trekkers and I disagree. I like being able to completely suspend my disbelief, they don't.
I also think that since technobabble isn't actual hard-science, having it in there is just really half-assing it. Either go full hard-science or trust in our ability to suspend disbelief. No half-measure technobabble that insults everyone's intelligence.