I'd say Thundaga, Holy, and Flare are the most visually impressive spells in FFI. I haven't seen all the spells in FFII yet, though.