The end of Enterprise should not have been a holodeck retelling featuring Riker and Troi, it takes away from the series by trying to pad ratings with people from a more popular show, just like when they had the Ferengi in an episode and the Borg. The premise was supposed to be the founding of the Federation, so show that. Not just have a last episode or two devoted to it, but the last season should have been about some galactic calamity, war, fighting, and then the principle players realizing the need for a united organization and working towards that.
Amen, Brother!
The ending of Voyager at least featured what was expected, although like many finales everything happened at once.
Plus the whole concept of Voyager is basically that the crew is inferior to the TNG crew, because the TNG crew got trapped in the Delta Quadrant way back in season 2 and got back home by the end of the episode.
Because I don’t believe in reboots, I have no idea how that one did end. In any event, I would let events unfold the way they did for the audience that did watch the series.
BUT, at the last moment, I would add a scene where Dirk Benedict comes crashing through the scenery (think the “Doin’ the French Mistake” scenario from Blazing Saddles), followed by REAL Cylons, the shiny toaster kind. He defeats them all in a blaster shootout that happens to leave the entire cast of the reboot dead. He fires up his communicator device, and reports: “Apollo? Starbuck here. Let Commander Adama know that the last of the Cylons have been destroyed. There’s been some collateral damage, but it wasn’t very many people. I’m sure the rest of their civilization will be fine, unlike ours. <beat> Huh? Just a centon, I think I hear something.”
Starbuck lifts a collapsed wall and out crawls the chimp in the robot dog suit. Starbuck keys his communicator again. “Apollo? Good news! I’ve recovered another survivor from the Galactica.”
“It’s gonna be all right, boy. Everything’s gonna be fine.”
FIN
CSI
They all go to a Who concert and the last song is “Who Are You”.
Cougar Town
They all go to a Bruce Springsteen concert and Courteney Cox gets up on the stage during “Dancing In The Dark”.
Galactica 1980 should have ended with operatives of FLAG discovering the remains of some cylons and taking them back to their scientists for reverse engineering. “Boy I bet this stuff would really be a boost to the Knight Industries Two Thousand project” one of the scientists could say.
“We’ve finally figured out how to make a red light move back-and-forth on the front of something. This is a real game changer!”
Hogan’s Heroes - Colonel Klink finally discovers what the POWs are up to and has them all hanged with piano wire.
Ignoring the mysticism in BSG would be as pointless as ignoring the mysticism in Star Wars. Like SW, BSG was never science fiction - it was fantasy with SF hardware. The show made that clear form the very start.
Blackadder was a comedy series that went through periods of English history with Rowan Atkinson playing various descendants of the Blackadder family.
However the final scene had a remarkable change of atmosphere (it was set in WW1.)
I remember watching it with a load of my school pupils. They were laughing out loud at the puns and slapstick. But in the last moments the room fell completely silent.
Truly memorable.
But just before they are hanged, a high ranking nazi stops at the camp and insists on piano music before dinner. Hilarity ensues.
How so?
The prophetic visions were a hint. As was the near-complete lack of science.
Always thought the name “Hogan"s Heroes” was wrong. My heroes don’t get captured.
That did not deter many science fiction programs. 
Breaking Bad:
Instead of sliding the gun to Walt and saying “do it yourself”, Jessie pulls the trigger and shoots Walt dead.
Other SF has *bad *science; BSG was different in that it had no science at all. How did the ships’ engines work? What was the technology behind the Cylons’ artificial intelligence? What was the principle behind FTL travel? Who knows? There has never, ever been a space show with less technobabble, with fewer plots resolved by reversing the polarity or ejecting the warp core. It’s one reason I loved it so much.
We actually knew a fair bit about those things. The jumps, for instance, could in principle be arbitrarily long distances, but required extensive calculations, and precision suffered the further you jumped. The calculations could be done by hand, but were usually done by computer. The calculations depended at least in part on local astrometric parameters at both your starting point and your destination, and so jumps within familiar space were easier and safer than jumps beyond that region. Entering random parameters would still jump you, but it was incredibly risky, because you didn’t know where you’d end up. Smaller vessels like the raptors could still have jump drives, but they were less precise than those on larger ships, and so were only practical for relatively short jumps. For a craft the size of a viper, meanwhile, it was either impossible or impractical to mount a jump drive. The Cylons had better jump tech, and so could make longer, more precise jumps with smaller equipment, and the humans were able to at least partially reverse-engineer that tech to improve their own drives.
That’s a lot more about the practical operations of the FTL drives than we ever got from Star Trek. Or at least, a lot more than what we consistently got: The Trek creators tried to set rules like that, but were terrible about following them. The fact that they threw around terms like “warp bubble” doesn’t really make up for that.
“Almost as good as that sentient cpu. To think, we were about to farm that work out to Cyberdyne!”
None of that has anything to do with how FTL travel is supposed to actually happen. This is just how it’s dressed, to provide for plot complications and general atmosphere.