DISCO has definitely been the most inconsistent of the recent Trek series but I have to say that I have very few qualms with the past two seasons. While season 2 was entirely about the writers throwing their hands in the air and giving up the nerd fight over continuity (which was, IMO, the cause of most of the narrative awkwardness with that season - trying to find a way to justify getting them out of the present-day) the payoff of moving to the far future ended up being worth it.
Season 3 on felt more like a reboot of the show than a strict continuation and season 3 was, easily, the weakest of these three. Mostly because "psychic explosion" is a much less satisfying answer than a super powerful extragalactic race that's not recognizing the anthills they're knocking over. Or the idea that an ancient, super-powerful, tech is but an artifact of even more ancient civilizations than previously known which lets Star Trek return, just a bit, to the idea that there are actually great unknowable mysteries out there.
What I find interesting about DISCO is that, despite it being a very polarizing and, at times, contentious, show the writers are damn fucking great at creating characters that people want to continue seeing (and it helps that the casting department has been on the ball with most of them). It started with the excitement surrounding the Section 31 spinoff show (now movie), continued with fan cries for Pike's Enterprise to get a show and there's a bunch of people who are genuinely excited that Tilly might get to continue in Starfleet Academy (which highlights just how far her character has come from the "annoying and over-excited kid" trope she started out as). Add on that I'd love to see Callum Keith Rennie's Rayner return in the future.
DISCO might be inconsistent and polarizing but it's been a fantastic incubator for new Star Trek projects.