The big sci fi win in stargate is how highly they rated internal consistency and having a scientific basis where possible. Apparently that was mostly because the actress playing Carter absolutely refused to tell bullshit gobbledegook and forced the writers to do it properly.

It’s subtle, and not always perfectly followed, but if you take the episode where they gate to the black hole, they have significant screen time justifying why the time dilation is so strong when the gravitational effects are so weak. It shouldn’t work that way and they acknowledge that explicitly, but obviously they wanted a fun time dilation story so they call it out and explain it as an unexpected side effect of the gate wormhole. So sure, they sometimes make science do what they need it to do for the story, but they try hard to justify it.

Star Trek meanwhile barely follows its own rules most of the time, let alone actually acknowledging real physics