The PCs come across a town with a strange curse: Every morning, those who have grown up here wake up with the memories of someone else. They do not find this strange and have no idea it is happening. They calmly wake up and start these new lives as though they have always been that way.
The cause: A wizard who lived there was spurned by a maiden he was infatuated with. His attempt to manipulate her memories into believing they were already together and that she loved him went horribly awry.
A possible answer to what happens to spells when a mage dies. If the spell is strong enough, say and enchantment or other permenant effect, part of the mages spirit may become lodged in the magic. It may be a way for items to gain some kind of intelligence, but a mage who has knowledge of this fact would be very hesitant about enchanting anyone or thing. He might have other plans for his afterlife than counting the change in your bag of holding.
Preists, I think, would have this sort of thing covered.