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
The Nomin gypsies have a fiddling competition every year, known as the Danse de Velose. Beaters hit out the rhythm on taut drums and the competitors start to play, slowly at first. Youngsters can compete, but are soon pulled away by worried mothers, before the competition becomes too dangerous. After two hours the haunting tune has become dazzlingly fast. You can resign at any time, but the moment you make a mistake you receive an arrow through the neck. Strings may snap, but the players must play on. The whole affair never lasts much longer than three hours, and the last fiddler playing is crowned king of the gypsies.