Well for those who have been following the development of Stargate Worlds, Cheyenne Mountain Entertainment has just released Stargate Resistance, a third-person shooter!
It is rated T for Teen, and is available for $19.99 through Firesky/Direct2Drive at StargateResistance.com
The graphics are OK, a bit outdated, and third person takes a bit of getting used to. It is free to play online.
http://www.youtube.com/v/ACFkak9zZEU&hl=en_US&fs=1&rel=0