I do have lots of nostalgia for Stargate too, but going back to watch clips, especially from Atlantis, was a bit rough. There is also that fan-made Adventure Game Studio game, Stargate Adventures, which is insanely well made, and it could easily pass as a LucasArts game.