Modern Trek is a let-down, although Lower Decks has been awesome with lots of member berries sprinkled throughout for the TNG-era enjoyers.
I should add that Star Trek: Prodigy (albeit a kids show) has been very optimistic and enjoyable too, feels very much like TNG-era. Janeway and Chakotay are in as well.
P.S.
On a tangent The Orville (a Star Trek TNG clone by Seth MacFarlane) is pretty good; some Star Trek actors even show up in it.
Season 4 is apparently in production.
It's an attempt at reforming quasi fascistic points of view. Strong hierarchies, heavy specialization of individuals, etc.
It is also kinda nice, in the sense that it explores this idea that you should put yourself in the shoes of the places they explore.
It also sucks, because their fans like to put themselves in the shoes of the quasi fascistic spaceship troops.
So, in the end, it is a dystopian nightmare. Told from the perspective of the ones who brought the dystopia to fruition. Which makes it optimistic, I guess! Except for all the planets not on their control having to put up with them.
