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.
No thank you. They redid all of the exterior shots with CGI for the Blu-ray release, and it's jarring when compared to the scenes with actors. At least they had the decency to give you the choice between watching that version or the one filmed with little models.
I think we have to accept media as a product of its time, especially science fiction. There's really no way to "modernize" a show where they are feeding physical cards into a computer to program it without reshooting the whole thing, and then it wouldn't be TOS anymore.
There's a version of TOS in HD with re-done special effects. I assume they have new scans of the film because they don't seem to have the usual flaws of upscaling. The re-done effects are much better than the originals (probably) but I am not familiar enough to say. They do have a cheap CGI look to them though, particularly the ship models. Regardless I am enjoying watching them through, in order, for the first time.
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.