This has become my tedious hobby-horse topic, but I still don't get how DS9 gets grouped in with TOS/TNG/Voyager as "good old optimistic Trek". From season 5 onward it's way closer to Discovery S1 than TOS/TNG in tone, intent, and structure. Plus, both DS9 and Disco have the same posturing "stand aside, fools, and watch us mature writers bring your pitiful kiddy franchise up to scratch" attitude toward previous Star Trek shows.
Simultaneously I don't get how SNW could reasonably be excluded from the "classic optimistic Trek" mold, and I'm saying that as someone who has a lot of increasingly-strong criticisms of the show.
It makes me wonder what would have happened if Discovery had released in the mid-90s - would everyone have been like "oh yeah, what a breath of fresh air"? Or if season 5 - 7 of DS9 released today, would people be like "yet more tedious Kurtzman Trek grimdark slop"? Or if SNW was made in 1995, would it have been "peak Trek"? I think the timing of these shows does a hell of a lot to affect their perception.