I’m on that side too :D I like both but am a bit of a sucker for tragedies and non-utopian fiction.
I do, however, agree with your thoughts on the narrative direction. DS9 did indeed open the door for less-Treky series that I don’t think necessarily benefitted the ST universe and probably would have been better as independent sci-fi series in their own settings.