The premise was great: I wish they'd done something with it.
I'll be the first to critique VOY (and other Trek) writers for missed opportunities... and that at Warp 9.975 it would take VOY less than a week to get back because 9.9 = 21 473 x C as it was established in dialogue. Past 9.9, each incremental increase results in doubling of speeds.
If they actually stuck to that idea, then Voyager should have been thrown about 206 million LY's away (well beyond the Milky Way) and that it would take them about 75 years to get back at Warp 9.97 (slightly lower than the touted maximum sustainable cruise velocity which is technically rated as a speed a ship/object should be able to safely sustain indefintiely, or for as long as their resources last).
I was disappointed they were thrown halfway across the galaxy only - but lack of Warp speed consistency (and progress in making it faster on part of the writing staff) has been a common trope in all of Trek... DS9 included.
As for other missed opportunities... those were largely network exec issues. As I said, the series producers wanted to make season long arcs, but the network didn't want that, so it insisted to keep VOY in serialized form as TNG.
I still prefer VOY to DS9.
I like some of the characters, but compared to Kirk, Spock, McCoy, Picard, Data, Worf, Sisko, Kira, Odo, Quark, Nog, Garak, Dax...maybe 7 and the EMH are at that level, and Tom and B'elana are solid....
What, no Janeway on the list?
I thought she was quite solid and far more likeable as a captain than Sisko.
Kes was also quite interesting and I was sad to see her go. I'd say that Neelix, Chakotay and Kim were fairly weak as characters (or ended up as such)... actually, Chakotay started out strong, but then progressively got less development.
Kim also underwent certain points in the series where his interests shifted and personality overall grew... although his lack of promotion was grating.
As for most of the characters you listed... I didn't really care that much about Kira for example, or Quark. Worf was a familiar face from TNG yes, but he certainly didn't distinguish himself as chief of security and all that trope about honor also got a bit boring. Meanwhile, Odo was actually ok, but sometimes he just ended up unnerving me.
Dax was a good character actually. Sisko... I hated how he basically ended up downgrading himself from SF and scientific principles in favor of Bajoran faith. To me, that was absurd.
He was also quite ignorant on historical aspects into what prompted humanity into having the Bell riots for example - even though he should know it was a socio-economic system coupled with lack of relevant education... but Trek writers almost never could explain this adequately... its as if their understanding of these issues is (or at least was)... non-existent.
Or they selectively opted to make Sisko ignorant of this.
I also didn't care much about Sisko's episodes where he was Benny the writer. Honestly, it was pointless to me and boring.
I already knew that black people endured slavery, massive prejudice and bias from society (and in fact, still do - what was showcased in the episode however was watered down version of the horrors people endured).
But what was the point of dredging that up for Sisko? Is it part of history? Yes. Should it be ignored? No.
In the context of 24th century, that would have limited meaning to Sisko... it would in fact serve as a reminder of the terrible past and just how important equality, personal rights and 'freedom' (as loosely people define it) are, but he would already know about this.
The writers (and the wormhole aliens) could have found better ways to 'test' Sisko as opposed to digging up a scenario that in-universe wise would be completely irrelevant to him from a cultural perspective because he's a 24th century human... not a 20th century one. He's centuries removed from those kind of behaviors and would have probably learned about it as part of his basic education (as would any other human) in his era. I doubt such discrimination would exist in the 24th century UFP (in fact, it shouldn't have existed at all when humanity solved most of its issues in the 50 years since First Contact with the Vulcans- and as it was confirmed by Cassidy, its all long part of history - and for Sisko to fixate so much on this seemed... hollow).
Like any other SF captain, he would care about individual rights and freedoms being suppressed and would fight for them (or at least I'd expect him to)... but he wasn't in a setting where black rights would have been contextually relevant to him.
Picard was in a similar setting... when he was temporarily captured and tortured by the Cardassians for example.
Maybe if something like that happened to Sisko in the 24th century, it would have carried more significance.
Heck, O'brien mental torture (which to him lasted decades and was quite real) had more significance in how prison can change a person for the worse and strips you of your basic rights.
Sisko would have also experienced something similar during the Bell riots.
You can if it is, but often on Voyager it wasn't so they didn't. They couldn't be bothered to learn what an event horizon is or what the term "theoretical impossibility" means or how evolution works before writing stories revolving around them.
You do realize you described ALL of Trek there, right?
The writers of any series have 'consultants' apparently but for some reason, they are incapable of writing good stories that fit a technologically advanced setting and end up messing up most of it anyway (and how difficult is it to pick up a calculator to come up with a proper time frame it would take at certain warp speeds?), therefore, they end up dumbing things down. DS9 did that quite a bit... maybe not on the technobabble level, but it was just as guilty of dumbing things down like any other series... even excessively so.
The Siege of AR558 by far showcasing the biggest dumbing down I've seen in Trek, or the fact that 2000 dominion ships would be a threat to the ENTIRE AQ (aka a quarter of the Galaxy), even though the UFP as a whole is comprised of over 150 member planets, stretches over 8000 Ly's, and should have had nearly 80 000 ships running around (building at least 1000 ships every year in peace time, and could probably churn out at least 10x more in same or less time if necessary during war) by the time the Dominion War broke out.
As I said, Ds9 cut corners to a pretty large extent in many areas... enough to make the series a lot more 'closer to what's happening in reality' with people exhibiting same patterns of behavior... or starting out differently (more in line with Trek), only to degrade into everyday nonsense of behaviors - which is something that didn't make me like DS9 that much.
Not a fan of In the Cards? Take me Out to the Holosuite? Nearly every Odo/Quark interaction?
Not a fan of the Cardassians. Some interesting characters and episodes, but overall, meh as a species.
Take me out to the holosuite? Are you kidding me? It was one of the worst/boring Ds9 episodes for me.
Odo and Quark interactions were a cat and mouse game fed to the viewer constantly. Some good moments there yes, but on the whole, a bit repetitive.
Were you also disappointed with TOS in that regard?
To this day I hadn't seen much of TOS. Only a few bits and pieces, and every time I try, I just can't get into it enough.
I liked the TOS cast ensemble enough in the movies, but they also came with their own set of caveats.
Not enough to dislike them... I just liked VOY, TNG and ENT characters better (and yes, I know ENT took a lot of what it did from TOS).