As a developer, it's really awesome to see how people can take ones game engine and use it to make some really interesting stuff.
Some GalCiv II players have gotten together and made a Babylon 5 total conversion. There's mods for lots of other genres. Obviously these are not officially sanctioned or supported but for people not afraid of modding, heck out the game play example a player made.