I never heard the faintest rumor of anything having to do with "Starfleet Academy" until they were looking for a story to succeed
Voyager, and later for a new venue for the movies. In none of those cases did any of the concepts involve the characters of Kirk or Spock.
maybe that's why I am also losing intererst in both tv and Star Trek in general
Well, if happy endings are your problem you're also going to have to avoid movies, books, the theater, opera and comic books. Because most of the time in most media you're going to end up with a fairly happy ending. Even tragedies more often than not have some kind of morally uplifting message and feature the triumph of good.
Richard III is the hero of that play, but he's also a Very Bad Man so his defeat and death at the end are a good thing.
Hamlet ends up with a huge pile of corpses on the stage and practically everybody who's had a speaking role dead, but it also ends with the murder avenged, the evil king and queen gone, the curse lifted from the country and a - presumably - decent new ruler in the person of Fortinbras taking over.
Gone with the Wind (book and film) end with Scarlett losing her husband and her daughter, but still believing that "tomorrow is another day."
There are some tales, even fairly popular ones, with very bleak endings, but they are few and far between because people simply don't have much appetite for that sort of thing. We all have more than enough sadness and unpleasantness in our own lives. For exactly that reason we prefer to immerse ourselves in entertainments where things are
less bleak, where problems (which drage on for years in our own lives) get solved in 30 mintues or an hour, or a couple of hours in a darkened theater, where good overcomes evil (as it so rarely seems to do in real life) and where the ending is happy.
In the depths of the Great Depression one of the most popular American film genres was the screwball comedy - which generally depicted the foolishness of the very rich. People didn't want to watch socialist-realist tracts about living in poverty. If folks wanted to see people living in poverty they could look out the window - or in the mirror. They wanted to see people
not living in poverty, going to speakeasies and nightclubs, sneaking in and out of bedrooms in tialcoats and silk nightgowns.
In a medium like television, which has to appeal to the broadest audience, and in any form of series, where you want the audience to come back nex week, there isn't a lot of room for downers. Even
B5 didn't do a lot of episodes where the bad guys lost.
As for the
Treks "doing the same story over and over again", you aren't being fair, don't remember the shows very well, or didn't watch a lot of them. At their worst (
TOS in its third year,
Voyager for all 7) the shows could fall into formulaic storytelling. But when they were on their game they demonstrated a great range.
TOS alone essayed comedy ("The Touble with Tribbles"), farce ("I, Mudd"), tragedy ("The City on the Edge of Forever") and psychological study ("Obesssion", "The Conscience of the King") Hardly "the same story"
Regards,
Joe