First, let me state for the record that the Stargate setting is one of my favorite of in all of sci-fi. Only the general ignorance of the setting by my group has prevented me from shanghaiing them into a game.
One of the key points of the Stargate setting is balancing issues. Remember that an SG team should be able to overwhelm even a numerically superior Goa'uld-aligned force. But the combat was never a central facet of the story. The central goal of the average episode/arc was to find some scientific solution to a greater problem, any skirmishing was almost window dressing intended to provide a ticking clock. Particularly poignant examples include: [spoiler]The dual scene of a group of Jaffa on Dakara and O'neil and Davis on Earth holding off replicators during the calibration of the Dakara Super Weapon, the air battle in Antarctica while SG-1 secured the Ancient Weapons Platform and a combined Tau'ri-Wraith-Traveler fleet engaging the Asuran Fleet, as a distraction in SG: Atlantis and the entire war against the Ori which was almost entirely consumed by the serch for the Sengraal[/spoiler]
The salient point of this is that any system that would do justice to the setting must have an excellent mechanic for handling skill tasks and investigation.
