>>712572161
>It would have sucked ass if it was stuck in static forever
It wasn't static at all.
And giving them a full-fledged warship is the bad kind of power creep. It also completely changed the dynamic into something StarGATE isn't suited for: pretending to be Startrek.

What would have helped would have been smaller spaceship doing commando stuff they couldn't do when limited to the gates. Like being blocked by the Go'uld also setting up their own ways to block the gate, which prevent the UAV + Missile solution.
Requiring commando operation to C4 their generator from the other side.

One memorable episode was the one where they use a small ship to reprogram a space-mine to sabotage a go'uld meeting.