I like both cool Sci-Fi etc but also admirable characters. I couldn't relate well to "Michael Burnam" of Discovery in the first season because her behaviour was so un-Federation. But in many ways we are in the golden years of Sci-Fi.
I loved BSG. Each episode developed characters, and while there were some slow episodes and season 3's hostage & rebellion narrative was a bit trite, the rest of Season 3 and the big reveals in BSG were amazing! Also the meta-narrative!
I loved Firefly before BSG - it was just so fun and lighthearted compared to BSG's dark and psychologically traumatised characters. There was a lot of 9/11 inferences in the first season of BSG.
I love The Expanse. Enough said!
I also love a youtube channel that explores the engineering of possible Sci-Fi worlds, called
Science and Futurism with Isaac Arthur. I look forward to every Thursday when fans greet each other with - "Happy Arthur's day."He explores what we could do with today's level of technology, just scaled up a bit.
He discusses what might be possible with today's tech. Imagine reliable solar power beamed down 24/7 from space? Or what about Huge O'Neil Cylinders built today's known materials? 8km wide, 32km long, spun up to 1g and perfectly climate controlled for our comfort (or whatever desert to frozen ecosystem we want to create.)
Megastructures in space could house unimaginable quadrillions of us just around our own sun, let alone the whole galaxy. That's possible with
today's engineering! Let alone the huge things we could build with "active support" structures. (Think of a how a fireman's hose can throw a fireman through the air when the water is really under pressure.)
It also gets crazy with a few new technologies that are
just on the horizon.
EG: carbon nanotubes in Space Elevators that might open up to huge continent sized McKendree Cylinders that house a billion people each!
EG:
Fusion might really change civilisation as we know it, and opens up the idea of indoor agriculture and truly food independent
Arcologies.
EG: Fusion candles that can hurl atmosphere off a gas giant, the purpose of which I don't want to spoil because it's so awesome! Please watch this one, which has a mildly boring middle but the punchline near the end is so amazing I was on a high for a week!
Isaac will sometimes even explore hypothetical or magical technologies, like what if we had force fields like out of Star Trek? He debunks the idea with today's physics, but then asks the 'what if' and explores whole new areas of potential for force fields that Star Trek authors never thought of. Those episodes also sometimes blow my mind.
He's been doing one a week for years now. You could probably watch one episode a day for about a year! Excellent youtube. His earlier episodes had amazing ideas, but the graphics were a bit poor. It's now a superbly produced show with a huge team working on it.