I just finished watching all 10 seasons of the old Stargate Sg1 Showtime/Syfy show on amazon prime.
After and nearing viewing it completion I began to heavily crave playing a game based on the Stargate universe, I quickly discovered that no major stargate games ever saw the light of day. Stargate alliance got canned in 2005 and the MMO stargate worlds was suppose to come out in like 2009 and there was some sort of scandal and MGM pulled their license and the MMO got canned as well.
I think Stargate would make for an excellent Action adventure game in third person or an FPS/Action game. I would prefer playing as Jack O'neil, Teal'c, or Ben Browder's character.
Checked out the videos of the MMO alpha or beta whatever and some of it made the game look very promising. The graphics were not that good but thats not important.