Civilization IV, already a fantastic game, is taken to the next level by the dedicated modding community. The Rise of Mankind mod, in my opinion, should be considered as the third expansion pack.
http://www.atomicgamer.com/files/846...yond-the-sword
Also, this site is fantastic for your Civ needs.
http://www.civfanatics.com