Star Trek is science fantasy. It has gods, space elves, space orcs, psychic powers and lots and lots of technobabble. But fundamentally, it's science fantasy.
Babylon 5 is science fantasy. It's literally a fight between angels and demons where the space elves and the humans join forces. It has techno-wizards for crying out loud. Sure, there is a gloss that this is all somehow sufficiently advanced technology but the sufficiently advanced technology is suspiciously chosen to look like traditional magic.
Battlestar Galactica in its original version was science fantasy. It's a little less science fantasy in the well done but ultimately deeply flawed reboot.
The Expanse of all the ones you listed is the hardest science fiction. But even it can't resist space zombies and protomolecules with unexplained magic powers.
Star Trek is decidedly a talking dialogue based story telling form where mysteriously lots of things resolve down to fisticuffs because plot. I personally would run it with something like Dogs in the Vineyard where you had explicit escalation mechanics.
Babylon 5 just needs hit points. It's mostly tier 1 heroics set against an epic backdrop, proving you don't need 20th level characters to run epic fantasy. There is though a lot of power of plot narrative protection on PCs. Certain things don't happen because they would ruin the story.
The Expanse I think started as a GURPS Transhuman Space campaign.