Every character follows its own strong trope.
Similar vibe to the self-importance of the 80s freeze frame ending. I like it BECAUSE it’s bombastic but I understand not liking it either.
I had trouble for a while with DS9 BECAUSE it was very different from what came before and after.
In fact, I never finished DS9 and it’s on my “to watch list”.. but I’m pretty behind. I petered off 1/2 way through Enterprise and saw only a few of the newer movies.
Voyager was probably my favorite ultimately.