Taking a few of the more interesting curses i've ever encountered:

Morphed into a pillar of salt.
Your name causes intense hate.
Your smile causes intense physical pain when viewed by those you love.
All you hate become lucky.
Greedy thoughts causes your eyes to weep blood for a night and a day.
Weeds grow under your body with frightening speed [straw beds can be deadly]
You lose moments of time whenever threatened [basically standing and staring]
You constantly smell of death, to the point where you draw clouds of flies
Your children turn into monsters, especially minotaurs.
You lose interest in your own species and become sexually attracted to another species, say, Orcs.
Your wounds burn with blue fire that ignites your clothing but causes you no damage.
Whenever you say a person's name, they hear it as a grave insult.