So I'll admit to not reading all of your post. It seemed a bit disjointed to me and I lost interest pretty fast, but I'm a huge Star Trek fan so I had to weigh in. I love them all. The Next Generation. Deep Space 9. The Original Series. Discovery. I love them all. Mainly because the people that made them, the writers, the producers, they really seemed to love what they do. There seems to be a feel of artistry involved in all of the Star Trek series.
The most recent one, Discovery, does seem to be an outlier. It clearly has some artistic differences with the other shows in the series, but I still love it. It still scratches the sci-fi itch in me that makes me love it so.
It's funny, but I didn't like DS9 at first. I'm not sure why, but after watching it a few times, I realized how writer driven it was. All things being equal, those writers had fun with that series and that's what made it exceptional. They really took some liberties and made it a little more experimental of a show. Which made me love it all the more.
I haven't seen Discovery and, after seeing the first episode when they aired it on regular TV, I'm not really all that interested. It purportedly takes place in the original timeline in order to pander to those who hated the Abrams films, but it retcons even more stuff than they did.
The design choices are hideous, both in terms of makeup and ship models. Whoever designed the Discovery should not have been hired, and whoever okayed it even more so. It is the ugliest spaceship I have ever seen. It also doesn't match other designs. I saw screenshots from a recent episode in which the original-series Enterprise appears side-by-side with Discovery. It couldn't be more obvious that they had different designers. They don't look like they belong in the same universe or time period, let alone the same fleet. As for the makeup, don't even get me started on the Klingons...