For me that was a rare outlier while the majority were well done. My biggest complaint with TNG were the seasons that centered around having Wesley Crusher on the bridge.. Firstly he just drove me nuts with that big dumb grin on his face LOL. Also the idea of having a teenager in a position where the life's of hundreds on board were depending on his performance under pressure, who hadn't even been trained by Star Fleet, fell too far out of believability for me. About the only characters I hated dealing with more were the Ferengi, I was surprised to see them resurfacing in so many of the different franchise series?
Back to the subject of SNW etc; I was never a big fan of Voyager, I just never thought Janeway worked well in the role. But recently I've been reviewing the seasons-episodes again on Paramount+, many of which I'd never seen before. Back in their day I was normally too busy with working and partying to watch TV. I'm still not a fan of her, but I am now being struck by the fact that it's writers were routinely capable of turning out good Sci-Fi based scripts each week with little to none of the silly BS nonsense that has packed so much of SNW. In fact there was much to criticize about Academy but yet they didn't have to resort to scripts that turned them into muppets, Fiar Tucks, Musicals, or some wedding fantasy crap. LOL JMHO