Forgive me if this has been asked before, but is there any good MII:TW mods out there that folks would recommend? Just looking to spice up the original campaign at little bit.

not that ive played it.. but thi mod looks good http://www.moddb.com/mods/third-age-total-war

I think there is a big one called Stainless Stell v.? (dunno what the latest version is) which a lot of people seem to play and is apparently really good

 

if you don't have Kingdoms your selection might be a bit more limited (think ^ that Bigsmoke linked needs Kingdoms)

I've played Stainless Steel, it is quite good. Makes the game a lot longer and move involved, which is both good and bad.

The "Darth mod" is quite a good mod, pretty small though not adding any graphical changes there are lots of cool little features and the AI is even better.