Our modding community is one of the best things we've got. That thread not only tells you what mod will work best for your version, but also give you a description of the mod itself.
It's hard to say what will be best for you, since we all have different tastes. Personally, I think Napoleonic Era looks really good, and it's got a finished version out for regular AoE3.