A Spell can Open, Move, Damage, Heal, Empower, Reduce any part you want of the target(s).
By Move I mean telekinesis, not a commonly used spell-type, but could also be such a thing as cyclone taking you away or a knockback, both of which do not need to have damage. Also teleport and blink.
Open, portals, gates, whatever you can think of the can be opened, or closed.
Damage, well kinda speaks for itself.
Heal also speaks for itself.
Empower, often used to empower the damage or survivability of a unit both of which ends in as heavy damage output you can get. But empowering something can be used in other ways which may end in Open or Move actions.
Reduce, or debuff, curse, whatever you wish to call it may also be used in a series of ways depending on which kind of map you are doing.
Basically it's all about what kind of map you are doing, if you are into making AoS style, then damage will be the most commonly found spell may it be indirect or direct.
But a Campaign, Puzzle, RPG, TD, the list goes on may use spells in so many other ways.