Everyone can think of a favorite song or two (or three) which can easily be translated into a fantasy rpg concept, be it an item, plot, location, or what have you. Just take the lyrics of your favorite real-life ditty, and go from there!
This is a scroll for every rumor or tale you might here from a friend or in a bar.
The characters are unwittingly embroiled in a rebel organisation, and must lead the Black Shield fighters to victory against the evil Halar, seeking out new hideouts, rescuing people from towns and generally doing what Robin Hood would have done in their situation.
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