My stargate campaign is in its second year and just last night in fact my players crashed an al kesh. But, hey, any landing you can be hauled away from on life support...
I will give you perhaps thw weirdest review of the AEG products...
Quality of the stargate non-mechanical resource materials, synopsis etc... excellent.
Quality of the game system they implement in that book... excellent. IMo the best modern d20 rpg ruleset to date. The skills and feats and classes all have the modern feel.
The quality of the two as a Stargate rpg game... poor.
yes i love both halves of the book and dislike them taken together.
if you see "Stargate as if it was done by Tom Clancey" as the game you want to run, then this would work for you. otherwise, the gear up rambo dressing mechanics and combat focus will likely be as much a "this isn't stargate" shocker to you as it was to me. personally , if their game had been "Hammer's Slammers" it would probably have been perfect, but hey, they still did good work.
My game is heavily house ruled but still uses some heavily modified AEG classes and i dropped a lot of their clancey-it-up stuff.
If money isn't an issue, i would advise picking up their books for reference material, then use your favorite rules light modern rpg for the characters... unisystem could do fine, world of darkness could do fine too. if money is an issue, just stick with your dvds and grab a free unisystem or action or fuzion or maybe fudge.