I watched all of Discovery. It is, by far, the worst of all Star Treks. (Disclosure: I have not seen TAS.)
The reason is simple: Discovery is really the Michael Burnham show. She is the Mariest Sue who ever Mary Sued. Discovery could have been a really great show if it had been an ensemble show because it has a lot of very interesting characters whom we never explore.
Instead, everything centres around Burnham. She is the reason for the war at the start of the show. She is the magical, fated solution. She is Spock's (adopted) sister and had immeasurable impact on his life. Even through timey-wimey things, her (biological) mother comes to save her and the universe.
And on top of all that is the crying. Oh, gosh, everything is so emotional on this show. There is a time and place for emotions, but Discovery was too much of it, including inappropriate times. Burnham and her maybe-broken-up-boyfriend stop in the middle of an infiltration in a hostile station to talk about their relationship.
Even the really great characters, Saru and (Emperor Georgiou) centre around Burnham. She is like a sister to Saru, she saved his life, he gives up being a Captain to continue serving under her captaincy. Burnham is Georgiou's daughter (not actually), and Georgiou's love for her (as much as she can love) changes her.
No one has a story unless its actually about Burnham. Or they get a story and then get killed off.
The best thing about Discovery is it brought Trek back on TV and it gave us the rest of this era of shows.
I watched every episode, all the seasons. It does get better over time, and the last season is the best of them (imo). I feel like they started to actually figure themselves out by the last season, but I'd still say it was okay, not "good". I think I would have liked a sixth season to see if it would have become "good".
If we think of Discovery as a drama show that's about people's relationships that happens to be set in a sci-fi universe, I guess it's an okay show. It's just not what Trek or sci-fi fans want: sci-fi. Was it a good choice to make that kind of show? Well, you know, I wouldn't necessarily say "no", but I don't think it should have been "Star Trek". You can have drama shows in space, just call it something else. Trek as a franchise has a certain level of expectation, and disappointment exists in the gap between expectation and reality.