The one thing I will say about PTW and mods is that it makes it a lot simpler and safer to switch between them than regular Civ3.
What are you looking for in a mod? Balance? The kitchen sink? Unusual Settings? Graphics? If you can answer that we might be able to steer you better.