Wow! You may have articulated exactly how I feel. Thanks.
My feelings on new series excitement have been affected by both time and Star Wars...
TNG, DS9, VOY, ENT... with each series after DS9 the quality dropped, in my opinion. VOY refused to work within their setting constraint and story quality wasn't where I wanted. Still, VOY has a soft spot in my heart and VOY is a guilty pleasure. ENT was a prequel, I was confident ENT would willy nilly disregard established continuity for sake of a mediocre story and they did. The stories were mostly bad until the last season and the final season was too many continuity nods in too close a time period.
Meanwhile the movies in the TNG era likewise declined in my opinion, despite INS being my favorite of the bunch.
At this time Star Wars makes a resurgence. I didn't care for the prequel trilogy. I thought maybe I was just turning into a crotchety old man at 30.
The novels were hit and miss. I used to read each one. I was disappointed by the quality of the authors (none of which are members here). A couple of authors I really disliked kept getting more and more novels published. The Star Wars universe shrank and suffered from small galaxy syndrome. Meanwhile in the Star Trek novelverse nothing ever mattered. All the toys were put back at the end of every story. There were no consequence. So, I stopped reading Star Wars and Trek novels.
I thought Star Trek 2009 was a great parody of Star Trek, but not my cuppa. Into Darkness was another tired attempt to capture the lightning of TWOK and was disappointing. I like BEY the best of the bunch.
So, by 2017 I had about 20 years of slowly growing disappointment over new Trek and new Star Wars. Maybe I was just a bitter old man stuck in the past.
But, then, Star Wars came through for me. I love Rogue 1, Solo, Mandalorian, and most of animated Star Wars. I'm not a crotchety old man that hates everything made after 1997.
Soi had high hopes for DISCO and modern Trek. My hopes were dashed, though. DISCO is yet another prequel that willy nilly ignores continuity for sake of a mediocre story. When it finally jumped to where it should have been set to begin with, the stories really didn't become more compelling. Ditto with PIC.
I love SNW but it leans too heavily on legacy characters or characters with nostalgic ties.
Modern streaming Trek doesn't tell engaging, compelling stories within their much too short of seasons. This isn't the format fault. Handmaids Tale, For All Mankind, Foundation, Westworld, Bel Air, The Morning Show... these series all seem to be able to tell much better, tighter, and more compelling stories in the same manner and format that modern Trek is made in. If Trek could pull this off, I'd be more excited.
I just haven't seen enough compelling Trek to get me excited about what might come next.