Stargate Worlds could have been awesome, but it was poorly funded and abandoned rather quickly which sucked (got super excited for it back in the day). But if Stargate ever becomes mainstream again I could see it working in a variety of genres.
Would love to play an X-COM style game themed around Stargate Command where you put together teams, build your base and gather new technologies (like time keepers... But you know actually good).
Or a co-op fps shooter like Vermintide or Left for Dead where you play as an SG team being sent offworld on missions and have a variety of classes/roles.
Could even see a 4x game like Stellaris working, but you pick a System Lord to play as and try to control/take over the galaxy.
Last idea was an exploration style game where you travel on the Destiny managing your crew and ship while trying to find a way home.





