Fireball was always tough for me to use in the BG series because it could damage your own party. One way to safely use it was through first using stealth/invisibility to scout the area, then put the mage just outside the view of the enemies, then blast them. But then you really don't get to see the full visual effect of the enemy's hair smouldering on fire. So except for the skeleton crew which I knew was always just outside High Hedge, I almost never memorized fireball.
Magic Missiles in NWN were blue/white. It might be cool to have them be random colors .. fireworks to entertain the townsfolk.
Well in this edition your mage can specialise in evocation and you wont damage your own party anymore.