The magic system in Heroes V [Discussion]

Does the animation of the spell play after the arrow hits?
What spells can be cast? I tried Cross, Magic Arrow, and something else.