The difference is TNG/DS9/VOY/ENT actually improved and got better after rough starts. That's part of the reason they became more liked as time passed.
You're no more of a fan of VOY or ENT than I am. Neither one of us is a huge fan of the UPN Trek series. Which means 20 years ago, we might've actually could've been on the same side.
I think VOY's best season was the fourth. I stopped watching ENT six episodes in, during its run, but this was my impression of it when I binged it in 2010 and again in 2020: ENT was
okay during the first season, the second season is -- IMO -- the worst season of Star Trek ever filmed, the third season was better (even though the Xindi Arc was something I couldn't get into until toward the end of it), and the fourth season is the only one I can recommend.
With DSC, the opinion of those who are lukewarm to it -- those who neither like it like I do nor dislike it like you do -- is that the first season was bad, the second season was okay (mainly because of Pike), and the third season is something they prefer because it's no longer a prequel to TOS. That is NOT my opinion, but it's the opinion I've observed.
IMO, I like the third season but I think it could've been a lot more. The second season gradually grew on me. And the first season is my favorite. So, in a very strange way, I agree in that I like earlier
Discovery better. But I don't agree about not liking the third season at all. I just like it a bit less. I see more possibility with it, so when it doesn't live up to that, I notice it more acutely.