I think you’re a little too hard on Star Trek. I’ll be the first to admit the writer’s could be better versed in their theoretical physics and a lot of the space travel is just technobabble. But the real sci-fi element of Star Trek (at least TNG and Voyager which are the only ones I’ve watched) is in how technology changes society. The best episodes usually revolve around how this advanced technology has changed the way people relate to each other and how that impacts their relations with species they encounter.
It’s not as focused on the political elements as BSG is but I’d argue that Voyager in particular was a precursor to that more mature form of sci-fi.
To give an example I remember one particular episode of Voyager where they passed through a section of space inhabited by a species that had banned anyone with telepathic abilities. Though there was an action component to the episode the real interesting part came when discussing the rationale behind that society’s decision and the impact it had on those forced to carry out those order. That type of scenario is where Star Trek really shines.
And this is annoying because Star Trek could be "what would the future be like?". They just have rubbish writers. Let me give you an example, the shields failing is a plot device, the ship is in danger, but it doesn't have to take any damage that would prevent the state of the universe being reset at the end of the episode. But in Enterprise, the writers were too lazy and stupid to come up with something new, so they did exactly the same thing with "hull polarization". Drop these writers onto a show about a present-day warship and they'd be stuffed. Whereas BSG's writers would take it in their stride.
The hallmark of real grown-up scifi is that state is maintained between episodes.