For me, Star Trek was mostly about a possible brighter future. Humanity overcame the issues on earth, no longer relies on money/capitalism, etc. When your watch the crew on TNG, they are acting professionally and with a code of ethics.

Discovery is so miserable. Everyone is angry all the time, there's racism, lots of unnecessary drama, people acting extremely unprofessionally. Same with Picard. Especially sour about how they made one of the best characters - Q - also very serious and miserable. He could've been the comedic relief the series needed, without undermining the rest of the story. The "Picard speeches" are just badly written too, so whimsical and empty.

We have a million dystopian Sci-fi series already, why do we need more? I feel writers are no longer able to tell compelling stories without fake drama. It's possible to engage with modern day issues in a different way, especially by showing how to be better.