I found every bit of Resistance one difficult, even on Normal... which is really sad, I know.
I hated the meteor level on Dead Space. Only beat it once.
inFamous has its share of spike moments. I was playing on hard recently, and as soon as I stood on top of a thing I got one shotted by a fuggin' rocket launcher. And the last boss? Fuck. That. Noise. He was soooooo hard.
Dragon Age had some difficult random encounters at first, like the time it made you fight a LEGION of wolves with traps all around. I barely survive every single time, and I never think to save before it happens, because, well, it's RANDOM.
And I never finished FF13 (Wasn't a fan of the game anyways) Because it pit me against Odin with that whiny little kid on my time, and Odin wiped the floor with me, and I had a high leveled sword too...