I still think TNG was the best, but DS9 was good too. In hindsight though, it seems like it was good to have someone like Roddenberry doggedly insisting upon his positive vision for the future. The modern Star Trek series, where there's nobody pushing for the utopian vision any more, are kind of depressing and not really in line with the idea that humanity will eventually be able to improve itself and leave behind the pettiness that holds us back today.
Yeah, I think that's fair. IMO DS9 got the balance right because it's a bit more gritty than TNG, accepts more complexity and ambiguity, but still holds up those ideals as something worth striving for even against severe difficulties.
I'm sad to say the newest Trek shows have just missed me.
Yeah same, there was the one that was both "in the past" (taking place before TNG I believe) but thanks to mushroom magic they had instant teleportation and then timey-wimey stuff so it was also a hypermodern show. The melodrama was just grating on me after a while.
Then there was Picard which actually showed some promise but I couldn't find myself caring about the new characters they tried to introduce on top of the layers of nostalgia. I heard it got a soft reboot or new writers for season 3 but I have no idea, I haven't heard anything about it.
Voyager was still good but that was the last show I actually watched on the regular.