Well its not all bleak doom gloom. There's Voyager
And Jean-Luc Picard would be the first man to charge against any pending "fall of the Federation" and would be the last man to fall. Since that won't likely happen, there's plenty of hope for a renewal. Who knows? Recent events might even shake up a few laws that would strengthen the Federation, make it more
idealistic (although I can't say how).
And I felt Losing the Peace
was a "positive, hopeful" story after the carnage of Destiny