...but for the long-term there was too much lazy writing and a lack of vision that plagued DS9, VOY and Enterprise.
You seem to have a very selective memory. All through Star Trek's history, quality has walked hand in hand with crap. There is arguably more bad Star Trek now than good Star Trek given the franchise's vast history and scope. But, honestly, that's almost to be expected.
Star Trek has always been mostly good with lots and lots of terrible. Season 3 of TOS was almost entirely garbage (to say nothing of some terribly cheesy episodes early in its run.) TNG had an appallingly bad first season and a deeply mediocre second season before hitting its stride. But even then, it was far from flawless. Season 5 was fairly weak and Season 7 was mostly awful, as the show was basically running on fumes.
DS9 is easily the strongest and most consistent of any Trek series, but also struggled to find itself in the first season and has its share of stinkers to be sure. VOY was almost all bad and ENT was only nominally better (though I didn't see the last season, where its fans insist it got a lot better.)
There was a running joke for years about how only every other Star Trek movie was good right up until the lousy "Insurrection" was followed by the even more lousy "Nemesis." Even die-hard fans would laugh and shrug and say, "yeah, that's just the way it is."
The reboot movies have been mostly bad. And Discovery is also a mixed bag with mixed reactions.
Look, Star Trek has some amazing stuff in it, some of my favorite filmed entertainment of all time. But it's also very, very fallible and has been written by at this point dozens if not a hundred or more different people over its long lifespan, to say nothing of the directors, actors, studio executives and countless other people that have affected its quality.
I'm not saying we should just throw up our hands and expect "Star Trek" to be bad. But it's not like bad Star Trek is anything new.....