Like many born in the mid-late 1970s, I cut my teeth on the original cast movies, and The Next Generation TV series. The problem for me was TNG movies weren't nearly as good as the films with the original cast. TNG (the series) was by far superior (to me) than TOS. But TNG just didn't come across as well on the big screen, for whatever reason.
Insurrection wasn't bad -- but it did feel way more like an extended episode, in comparison to Generations and First Contact, which I thought were good films (Generations more than FC). Agreed with Blob, who I believe said Nemesis is what killed it. I think the premise was good, I think Hardy is a really good actor, but it just didn't work.
Since then, I think Paramount has been spinning its wheels. DS9 was a good series, but rightly never cut out for a major film (the extended book series was good, but got a little too long in the tooth). Voyager was them trying a female Captain with the same premise as TOS -- and it didn't work for me. It just felt ridiculous (not a woman captain, just talking the series as a whole). Enterprise was a colossal failure, that tried to jump on the whole prequel trend.
The rebooted alternate timeline movies haven't really felt like Star Trek, and I think the rebooted cast thing is stupid.
Discovery -- now, I haven't focused in on it, except to know it is an original series, from some point forward from the original continuity (TOS, TNG, DS9, Voyager). But I have to say, it will have to be EXCEPTIONAL to draw me back in as a big fan. I was a huge TNG collector, which hundreds of carded action figures, ships, the entire series on video (DVD/Blu-ray), magazines, you name it. I just stored all of that stuff over the last few months. My wife tells me the person in charge of Discovery is really good, and I will keep an open mind. But I just don't have a lot of faith it will be pulled off well.
The fanboy in me wants to see TNG again. As a limited run. Something like how X-Files is doing now. Six or eight episodes a year. It can be done, and done well. But I am sure Paramount won't go for it. Not with them greenlighting Discovery. Another thing that has me annoyed -- I don't have a link, but I read last week an interview with Frakes, where he said he reached out to help on Discovery, to direct or help write some episodes, and they haven't even returned his calls.
That's such b.s., if you ask me.
So I am pretty soured on Star Trek at this point, unfortunately.