Nope, what you need for SG1 is a full scale tactical thing like UFO Enemy Unknown, where you go on missions and retrieve alien artifacts, and have to research them and build up your base as you go along. Your team members gain experience as they progress.
The missions could be a Republic Commando style thing, where you can give orders to your team, but with a little bit more depth. You could have foothold situation missions too where your base gets invaded, and the layout would be dependant on what facilities you'd already built.
Thing is, if you pitched the idea to an EA or a Ubisoft, they'd tell you to go away and come back with a plain FPS
/me wanders off to play UFO and call all the soldiers after SG1 characters....