i really want to know because DOW, as great as it is, will get boring so i want to keep myself entertained with it. any mod will be good except for any "Realism mod"(god i hate them)
uuhhh..lets see these are my favorites and you may like them left-out units 1.54 closer to codex:firestorm total war depth of heresy DowPro uber painter mod(get it from relic forums)
1. steel legion 2. daemonhunters 3. closer to codex 4. depth of heresy 5. imperial guard redesign + (balance mod)
Theres the tau and space hulk mod too, and dont get steel legion mod as theres a new dawn of steel mod coming out to replace that.
I've never tried any of them, but from what I've seen Space Hulk is great for an interesting new use of the game engine, Steel Legion is definately well done, as are the Daemonhunters/Sisters of Battle mods. Other than that, it depends entirely on what you want adding/changing and what you think the weak points are.
Oh, and Skirmish AI from Thudmeizer and co is apparently great if you don't like the normal AI.
thnx guys ill chekem out.