I mostly remember playing a total overhaul that turned the whole game into a fantasy themed world. Every civ had totally different playstyles, and there was a world-ending armageddon event that everyone had to deal with.

Unfortunately I can't get it to work on my modern computer anymore, otherwise i'd keep playing it