My alchemist had both of the fighting curses at the same time (magic duels and fist fights). Fortunately she had ranked up through the military earlier, so she easily won every fist fight. I was actually kind of enjoying it because I laughed every time she kicked their butts, but I got rid of them because every time she tried to go anywhere she was quickly mobbed by sims wanting to fight her.
My teen spellcaster had the curse that randomized spell outcomes, so once when she tried to repair the toilet she instead ended up with an extra broken toilet spewing out water in the living room (not to mention all the times she set the sink on fire). She also had the wraith curse and yes, the ghost is creepy! His eyes glow and he follows you around and screams!
Can't wait to discover the stinky and repulsive curses, haven't had those yet.