Niggles: Are Picard and most recent ST really that bad?
Yes, Picard is complete garbage, possibly the worst Star Trek ever made.
I recently watched it, and I wished I haven't.
I'm not going to spoil things for those who want to watch it, but let me briefly say this: the whole point of the series seems to be breaking old Star Trek universe. Whether you like it or not, Gene Roddenberry envisioned a future where people have no conflicts and get pleasure of trying to become better human beings.
In Picard, people have nothing but conflicts and arguments, use foul language, resort to drug abuse, and do things for monetary gain. And of course they have made a complete idiot of Picard, who can't do anything right.
The most embarrassing moment of the series is when Picard is first interviewed on TV so that the whole galaxy sees him, and later he goes on an undercover mission wearing an eyepatch. Yes, eyepatch. Adventure game logic. And of course as a part of his "disguise" he is using a silly fake French accent, even though he's supposed to French in real life.
And they bring a dead Trek person back from the dead just to kill that person again in the series. Stupid.
I'm not even going to comment on that Romulan Jedi Knight kid.
Even if we look past all Trek stuff, it's simply bad science fiction. They have some stupid holographic controls for their computers and ships and all, but none of that could ever work in real life, so it's there just for the sake of using CGI where pushing a button is all that is needed.