Except for DS9? To each his own, but I thought DS9 was one of the standouts...
I also enjoyed DS9, at least in the earlier parts, until we had Yet Another Mighty Alien Menace from Beyond to prat about with. The last series practically had me throwing things at the screen. Magic books? Summoning demons? King Ar-er, Sisko taken off to Avalon or where-the-hell-ever it was?
Waiter! There's D&D in my Sci-Fi! Pure vomitus.
I waited for something like three seasons for Sisko to tell those ruddy aliens to shove their meddling appendages right up their own wormhole, but it never happened. And, incidentally, to remember his oaths and the duties he conveniently forgot about whenever the Prophets crooked their metaphorical fingers. He did annoy me something rotten.
Turning to literature from TV for a moment, I much preferred Emerson's response to the Old Ones, in the novel Heaven's Reach.
"Because you didn't ask. Because you...never once said...please".
TV can be so disappointing.