I avoided watching this for 20 (!) years, because the reviews were ambivalent. But it's really fun. It's not awesome, like the Kirk/Spock series, but it's also (thus far) not excessively moralizing like TNG.
This is the only Star Trek (for me) that captures the wonder of the original series. The writing isn't great, but that was never a thing with Star Trek. They're also a bit kinetic, say, with discovering new Warp-Civilizations.
I also really appreciate that the crew is basically white, except for one black guy that's not blackity-black.
Even the chicks are fine. The writing for the Asian chick is a bit insipid, but it accurately reflects the chick version of the 'hero's journey'.
Unfortunately, they've introduced Time Travel, so I guess a few of the episodes are going to be tedious.
I liked it overall. The show drops off hard in the last season. There are a run of episodes, I think it's in season 3 where it's VERY serialized. Like each episode starting where the previous left off. Was interesting and fast-paced for a Star Trek show.
For me it's in order of overall best to worst: DS9 > TOS > Enterprise > TNG > The Orville (honorable mention) > Voyager > Picard > Strange New Worlds > Discovery
The latter two shouldn't even be labeled Star Trek. Picard is awful, just not quite as pathetic as Discovery/SNW I rate TNG lower than Enterprise, because simply by volume there are more TNG episodes I dislike or get bored watching, than there were in Enterprise.
I'd rate TOS higher than DS9 if there were a full AI remaster or overhaul or something to make it less dated looking. Please no remake or reboot, current day would absolutely gut it.
Enterprise better than TNG is bold but I agree with the rest of your list, except I wouldn't count Picard as Star Trek either.
Picard Season 3 is supposed to be better, but I couldn't even work up the energy to watch it after the absolute train wrecks that constituted the first two seasons.
Star Trek and Star Wars have both been ruined by current day production teams that don't understand the charm of the original at all and probably hate it if they do.