How about a dragon how cheerfully rules over a kingdom; his people all know him for what he is, and dragons are looked upon as wise and benevolent creatures. Dragonslayers from other kingdoms coming to free it from 'tyranny' are likely to get beaten to death by peasants with cast iron skillets.
Someone needs the blood of a dragon, given willingly, to make a rare potion. Guess who gets hired to sweet-talk a dragon into giving up some highly powerful blood?
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