Season 4 is great fun, action packed, and full of heroics, adventure, and great pacing.. It is the most serialized Star Trek ever got prior to DSC. And it
has an average of 417 TOS references per episode(if you're in to that sort of thing).
It's also really, really dumbed down, banal, overdramatized , and to use a modern phrase, "for the fans."
I will watch it, but I prefer to watch episodes from the other seasons.
The Dominion war stuff was fine, and had some of DS9's great episodes, but every attempt the show made to do an actual sci fi story after the 5th season was awful, while those other shows you mention had no problem pulling it off regularly.