A roll of 5,6,8,9 affect enemy units and daemons of the opposite god (all of which have to not be in close combat and as stated before have to roll a 6 for every unit). 2,3,4 Are terrible for the daemon player where as 10,11,12 are going to cause their opponent some trouble. Oh yes, 11 also affects us as it forces one random wizard on our side to take a LD test or turn into a new Herald of any god.
Honestly, in most games it won't make that much of a difference against us. Most of our models will simply just come back with IoN and that takes a lot of the terror nature away from the Reign of Chaos. The only game I really remember it making a difference is where Rot, Glorious Rot got super lucky and rusted out an dwarf's cannon.