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.
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.