"How is he? Will my son ever recover from the bugs that turned his brain to mush?"
The doctor pointed to where the thirty-seven year old was playing with toys on the floor. "It's been five years now and he has the brain of a child, give it another five and we can start the basics of teaching him magic again. He knows who you are but...but he will never have the same personality again, and by the time he regains all his magic skills at their former levels he will be in his sixties."
And in the name of the great and powerful I command thee to return to your body, hearth and soul, so that you might walk again and continue in the gods plans.
See that. . . wait. . . what!?! NO! I knew it was too risky here. You have brought ruin to us all. Why you ask? Ready your weapon, a traveler has come.
-Father Hayden, performing a ritual on the deceased outside the protection of the church.
The creation of intelligent magical weapons is not an exact science and there are occasional failures, as such think of causing a little more stress to your players by "rewarding" them with an insane magical weapon
Agrophobic, refuses to come out of the scabbard without a strength check to draw it.
Haemaphobic: afraid of blood, fight at a penalty against any blooded creatures but really good against undead, elementals etc
Schizophrenic, not just one mind in your sword, lets have half a dozen minds in there, all different and bound to cause confusion
the possibilities are endless