The TNG pilot really grabbed you... so did the VOY... DS9 didn't hook me... it took awhile... but then I decided I didn't really get it the first go. I'm hoping I get hooked.
The beautiful thing about a Star Trek TV series as opposed to a Star Trek movie is that they have the time to make changes to the show as they obtain feedback from viewers and critics. The only Star Trek to come out of the gate with great episodes is the original, which slowly got worse throughout its 3 seasons. The other shows took time to find their feet. It's a lot of trial and error. There will be a lot about Discovery people love and also a lot they hate - the beauty here (unlike with a 2 hour movie and your done) is that everyone wants Star Trek back, in what form though will just be a matter of trial and error.
Personally I still wish they'd paid closer attention to how the BBC brought back Doctor Who. With Trek I think you can draw comparisons with Doctor Who on multiple levels; both shows were born of then 60's, both shows have a long and complex sometimes convoluted and contradictory timeline and universe and both I feel work better as episodic television with broader character arcs being explored in the background throughout each episode.
I think of Star Trek being much in the same vein as Who in that there's a ship called the Enterprise (in who it's the tardis) and a captain (in who it's the Doctor) who commands and leads a crew (companion) to strange new worlds (time and space) etc...
I think Discovery has maybe gone in the wrong direction in terms of its structure, leaning more on serialised storytelling like Game of Thrones, that's the only big worry I have is that it won't have the same aspirational and adventurous quality to it that great Star Trek has always had.
I'm watching Voyager again and I must say I'm thoroughly enjoying it. I can see why it's the one Star Trek show that seems to have a lot of younger Trek fans even today. It's episodic television that has these great character arcs that they dip in and out of. Its not serialised and allows you the freedom to watch it at your own pace, It's such a fluid free thinking show. I'd never really paid Voyager much attention in the 90's but watching it now has made me realise just how much I miss that era of Star Trek. TNG, DS9 and VGR, those were great years and I think the point in which Star Trek had really found its place.
I hope Discovery can reignite that passion for Star Trek that has been somewhat tempered and deflated over the last 10 years. I am worried though.