There aren't too many mods for BFME 1 or 2. Most of the user content is
custom maps.
There are a few things you can get though, such as
AI improvements or
balance fixes.
There are about eleventy billion mods for MTW 2. There is one called
The Third Age, which is a Middle Earth mod.
Many other mods can also be found
here.