I would just like to let you know there is a Stargate Mod for the upcoming Half-life 2 game, it will be set in the SG1 universe and is bound to kick arse, The Mod is still in development and is waiting for Half-life 2 to be released so it can be completed but there is some media on the site and hopefully there should be some more added later this week.
For more info click the link below. Dont forget to sign up for the forum while your there.