The Campaign mode looks good, but the AI behaves irrational, shuffles around tiny units from A to B and from B to A without any other meaning than to slow down the AI's turn. I must admit I haven't tested any NTW mods yet to see if there is an improvement.
I played RTW and MTW2 before (IMHO RTW was the best of these and the engine is best suited for that era). Recently I gave Napoleon Total War another go, but I got bored again after about 3h.