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.