All I can say is that I haven't liked what we've gotten, and the shows seem to actively misunderstand what people liked about Star Trek in the first place. But then I never thought it was a good idea to give Alex Kurtzman and Akiva Goldsman the keys to the franchise.
I guess you're right that there is a good deal of time unaccounted for between Discovery and the time jump, but by that point in the show I'd already stopped watching. I wasn't sure of the exact timeline. (The fact that the incident is called the Burn is still goofy as hell to me)
This is the first I'm hearing of a sitcom, but now having read up on it the fact that Justin Simien's the co-writer is a big nope from me. I didn't like The Office or Parks and Rec, either (which are apparently the tonal inspirations).
Prodigy's a children show, so even if it is good for what it is, that style of storytelling will never appeal to me (just like Clone Wars and Rebels). I didn't know about the Khan podcast series, either. I'm glad that Nicholas Meyer's work will finally see the light of day in some fashion, but it's troubling that the final scripts are by streaming era Trek writers. I'll probably still check it out, though I'm not a fan of audio dramas.
I was interested in Noah Hawley's movie that got cancelled, but after watching Alien: Earth I think we might've dodged a bullet.
I grew up on 90s Trek, so I'll admit to being biased about certain aesthetic and dramatic choices. I don't like how flashy and action oriented the franchise has become, or how even Picard modeled its style on the garish look of the Kelvin films. I want stories that are about philosophical ideas that feature a crew that I enjoy spending time with. I don't want new actors playing legacy characters, which is a big part of why I couldn't get into SNW (that, and the intense theater kid vibes).
The last time I was actually excited for a Star Trek show was when Patrick Stewart announced his return (which feels like a lifetime ago), and it ended up being a disaster. I think at this point I'd be okay with the franchise going dormant again.