Are there any videogame RPGs with non-combat magic?

In every RPG on PCs or consoles, almost every magical spell is combat-oriented, and usually a variant of damage, heal, buff, etc. This makes playing a wizard a little dull, as you can't do all of the fancy fun you see in movies, books or pen-and-paper RPGs. Are there any RPGs that offer something different? I remember Planescape: Torment had a spell that allowed you to speak to zombies.