Magical curses are rarely cast, as if cast on someone for fun or purely maliciously and the person cursed has not done something seriously wrong, it tends to ricochet back on the curser. Therefore the few who do get cursed are shunned by most people as genuinely guilty,and few will help them.
The words of a wedding vow contain a strong love spell which enchants both the people who says it, so they will allways be deeply in love with each other.
Little halflings are told that if they don't behave, a demon called Santa Claus from a hell of ice will kidnap them and force them to toil making toys.
A PC Conjurer or summoner, basically any mage whose sole purpose in life is summoning creatures to aid in battles and various situations, is cursed with a hex, and needs to find a way to undo the curse...before he goes mad, or his fellow PCs throw him out of the party, or worse.
Everything he/she summons, never goes away. So you'll have to figure out what the heck to do with that dire bear or fire elemental once it's done fighting the orcs for you. Eventually a caravan of bizarre creatures either annoyingly ends up following the summoner around, or they go off to cause mayhem elsewhere. Bad news for the poor spell-caster regardless.