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
A healing potion which if drank by males (or women in male clothing) causes a short term (1 d6 hours) urge to dress in girl's clothing due to the high levels of estrogen in it.