Recently Boomtown featured some of the best mods available for the Total Wars series. Those modifications would surely enhance anyones experience of TW and the amount of effort involved in making such modifications is enormous. So much so that the majority of projects undertaken are never finished. Luckily one of the most sought after mods for MTW2 will be released very soon.
The mod in question is 1066 which is being created by some of the best modders that the TW Community has to offer. This won't be a mod that just tweaks MTW2 but actually creates a whole new campaign which should provide a fresh new single player experience for all those who crave some more MTW2 action.