I own the SG1 RPG, and I've played it more than a couple of times...really this game and Spycraft 1.0 were steps on the path to AEG/Crafty Games Spycraft 2.0. I enjoy the campaign ideas and structure from the SG1 RPG, but I prefer the revised rules from SC 2.0 to run it.
In terms of the campaign itself I think it does a good job of replicating the show...there is a decent balance between military weapons specialists and reasoning scientists if you allow for it in your campaign. The small teams are INSTANT plot hooks...my players and I found we could do pick-up games fairly quickly and easily.
"A hunter of shadows, himself a shade"
Homer, The Odyssey (II, 572)