Here is list of spells that don't work at all, and possible reasons why:
Doesn't decrease enemy health, not heals the caster.
Also, both heal and drain visuals are shown on the target.
Reason: Probably StealUnitStat attribute is bugged.
2) Crush Spirit
Doesn't decrease enemy morale at all.
Reason: AdjustUnitStat attribute just doesn't work with CurMorale as string parameter
Solution: see Fear spell. It uses IncreaseMorale as attribute, which properly decreases moral (also ModType needs to be TacticalUnit in that case)
Doesn't increase morale at all.
Reason: same as above
Solution: same above. Only difference is that using IncreaseMorale as attribute only works if there is no set duration (so it needs to work for whole combat, not just 3 rounds).
Doesn't work at all.
Reason: Probably IncreaseDecreaseUnitStats attribute is non-functional
Solution: Can be worked around by using two modifiers with AdjustUnitStat attribute
Reason: SetUnitStat is not functional
Solution: Can be worked around by using AdjustUnitStat attribute
6) Burning Blade
Reason: Missing parameter for AdjustUnitStat, so game doesn't know which stat to modify
Also, calculation is way off (multiplications instead adding static bonus to attack), and there is no duration set.
7) Shield of Fire
same as above
As a bonus, spells that work but with some bugs:
Wrong calculation when applied to stack
Reason: penalty is applied per units inside group, but calculation uses total combined attack rating.
So unit with 4 guys at total attack of 40 will get penalty of -20attack to every unit inside. That means 10-20=-10 attack rating per unit, or final attack rating of -40 for group.
Also: wrong calculation when applied to strong creatures
Reason: penalty is applied to unit base attack, but calculation uses total attack rating. So if troll with strength of 30 has attack of 30, his base attack is 10 (10*300%=30). And when 1/2 of 30 is deduced from base of 10, you get -5 base attack, or negative total of -15.
2) Bunch of damage spells
shard damage bonus not working
Reason: It's not defined properly if shard bonus stat is pulled from spell target or caster (missing ValueOwner parameter in final calculation)
3) Bunch of morale spells
shard bonus not working
Reason: same as above