I grew into DS-9. At first, I jokingly referred to at as the Bus Station in Space. Then, the character development and story arcs became engrossing. I really came to appreciate the Ferengi and liked the Klingons.
Right now there is no current star trek series.
I really, really wish they would just dip into their fan fiction and develop a Star Trek Anthology series. Kind of like the old “Twilight Zone” where each episode had its own characters and development. If you can’t do it in an hour, do it in 2 or 3 hours, 2 or 3 episodes is okay.
I never had the time to follow DS9. My impression of Sisko was that he was “too perfect”. He needed a fatal flaw or 2.
DS-9 did improve, I think they were forced to by being in competition with B5.