I still vividly recall seeing Stargate in theaters when it was released, and I never could have expected it to have the fandom it has today. While memorable, it wouldn't truly take off until Stargate SG-1 took the series in a new direction, paving the way for several continuations and a lifelong legion of fans.
The series appeals not only to sci-fi fans but to action fans as well, creating a unique nexus not shared by all its contemporaries. Now you can try Stargate: Pegasus Chronicles, a celebration of the entire series, not just one or two aspects of it.
On Steam, you can find Stargate - Empire at War: Pegasus Chronicles, available for free asa total conversion mod for Star Wars Empire at War. Released in 2006, Star Wars: Empire at War was beloved by strategy fans, and a modding scene started pretty much immediately after its release.
The fact that it was released on PC-only was a huge reason why, back when modding communities were starting to take off even more than they did in the '90s, with increased communication and collaboration among fans. As far as the Stargate conversion goes, this isn't your average modding...
