I get why Trekkies hated on TNG when it first started. They liked TOS and then the network canned it. And the fan-favorite cast, who weren't paid all the much to begin with, got typecast and couldn't get work. IIRC, I remember hearing at least one of them around this time had become homeless and was living out of their car. It was the Trekkies who saved the actors by paying them to come to conventions (which were a new thing, organized by the Trekkies). The devoted audience of Trekkies was why the TOS movies got made. And then the network comes along and says "Good news everyone, we've decided to reboot your favorite show, minus the actors you know and love because they're too expensive. Come give us your money." Of course the fans are going to feel betrayed and exploited. And it doesn't help that s1 of TNG wasn't great, and s2 was uneven (but had some high points).
But then TNG came into it's own and was amazing, and kicked off "Kirk vs Picard" debates. TNG opened up the door for Trek to get rebooted and for entire casts to get replaced.
DS9 got criticized at the start for being on a space station. How can you seek out new life and new civilizations from a stationary position? What are they gonna do, just sit around and talk to each other? (Yes.) I think DS9 is best seen as a side story to TNG/Voyager, and it's really great, even if it's different. And it introduced some things that became poison to the franchise like Section 31.
Voyager was TNG 2.0 (with a new cast to save money), but the TNG writers were too tired of writing TNG by that point, so they came up with new ideas, and then immediately abandoned those ideas.
Enterprise was TNG 3.0, with new ideas, promptly abandoned. Voyager had some ups and downs, but Enterprise was mostly bland to me.
The TNG movies were pretty much wrecked by actor egos. Shatner's famously the big ego of Star Trek, but Shatner only ruined one movie with his ego (Star Trek 5), while Patrick Stewart and Brent Spiner's egos ruined every TNG movie. While DS9, Voyager, and Enterprise never got the chance to have any movies, which was a shame.
The JJ Abrams movies were mostly disposable fluff. Some good, some bad. Whatever.
I didn't like the Discovery pilot episode, nor a couple other points where I tried to peek in. It just seemed like with Discovery, Trek evolved and became something I'm not really into. It didn't seem offensively bad to me, although I know some people have higher or lower opinions of it. And I know people have said that it's getting better. With any luck, the show will come into it's own with time like TNG did, and become something really special. I want Star Trek to be good, and something that people can enjoy (and if I can be selfish for a minute, I would like to enjoy it, but I'm fine if it's just for other people).
"Picard" though, that was a show that I had high hopes for. And it crushed my dreams magnificently. I really hated it. I don't even want to think about it.
Lower Decks got a look from me because I like animation, even though it looked like Rick and Morty and I'm not really into Rick and Morty. And I thought the first episode sucked, but I kept going, and man, that show really clicked with me. I loved how the show has seen all of Trek, just like I have (well, most of it), and how it can embrace everything about the franchise, the good and the bad. I liked it's sense of humor, and it still managed to tell stories while dropping references and making jokes. It seemed to line up with and do a better job than it's contemporaries (Discovery and Picard) in a couple of places.
Strange New Worlds might be good. I've heard that Anson Mount as Pike was one of the best parts of Discovery. I know I don't have a great track record with liking new Trek, but I'm still open to trying more.
Honorable mentions go to Galaxy Quest (a movie about what if the TOS actors got abducted by aliens), Babylon 5 (more DS9 than DS9, and a landmark in serial storytelling), Battlestar Galactica (Ron Moore's response to Voyager), The Orville (Seth McFarlane's TNG roleplay), and the Star Wars sequels (which make JJ's Star Trek movies look like Citizen Kane).