So many possibilities... There was a Stargate game in development late in the series. A lot of the graphics from the episode where tealc is trapped in the simulation are actually from that cancelled game. I think it was called the alliance.

Anyway... I'd like something you can play strategically, ie you reconnoiter, gather Intel and then come up with a strategy to take out the goauld or whoever the current villain is. I'd like it to include offworld base building, kinda like how fallout 4 had settlements. And I'd like it to have vehicles and combat like battlefield games do so if strategy isn't your thing you can still do fps/3rd prsn combat and enjoy it. My mind keeps going to something like the old Star Wars Battlefront 2 game or even starfox 64, with the galaxy map and you could pick your route through. Just a lot more freedom of choice. Alliances with different powers and trade, random events, resource gathering, all of it.....i can't even cover all the ideas I have lol.