A game was in the making (Stargate SG-1: The Alliance) but was stopped in the middle for multiple reasons. That was a while ago. Since then, no news. "Many" games were made but none really major or "official"
From my point of view, the subject had potential... it could be a very nice shooter. But the task was given to a "no name" and was lost in the chaotic world of gaming.
I always thought Ubi would have been the best to create this kind of game, the best to create a shooter worth the franchise.
Ubi, you should get in the project!