Honestly, aside from Star Trek into Darkness and Discovery S1-2, where the writing is just fucking awful all around, there isn't all that much bleakness in post-Berman Trek.
Like, any and all foibles Starfleet/the Federation have in Lower Decks is something they already had in Berman era Trek...