Two that spring to mind for me are Batman: Arkham Asylum 100% All Achievements or Resident Evil 5 Professional Solo. Two torturous but somehow enjoyable experiences I never want to go through again! Those challenge maps on AA especially had me pulling my god damn hair out.
I've decided to put my fears behind me. I'm not going back.
If you're gonna scream, scream with me