The best mod for the AI is with any dout RTW 1 with darthmod. When I played it was the first time in years that I saw the AI kicking my ass. Just try it
Then you also have Medieval II total war with mods like Europa Barbarorum II, TATW, etc