A lot of DOW's more infamous issues are hard-coded into the SDK and cannot be fixed without extensive modification to the interface for example, until it was patched, there was no way for modders to fix the targetting bug possessed by Tau Broadside Teams and Imperial Guard Heavy Weapons Teams.
On the downside, there's an extent to which Modding can do.
Alternately, they can change weapon and damage algorithms to make the game more balanced, ratchet back overpowered units, or add whole-new-units or factions! All of which, it needs be said, is Awesome. It can re-add slashed content (such as the Flamers for the Imperial Guardsmen, or optional weapon upgrades for the Imperial Guard Sentinel), it can make better use of existing resources (making weapon and tech-tree upgrades that make sense, for example), or it can mod how some units operate to make them closer to their codex equivalents. Modding in DOW can do a lot of awesome things.