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
There is a certain kind of silver-coloured spider who's bite injects an addictive drug into the person that creates a sense of euphoria. Once bitten the PC has a 50% chance of being addicted to the spider's bite and will carry it around with him or her.Long term use leads to serious injury or death.At first the PC will just seem a bit slower or sleepier then normal.