In regards to just more recent games, I found Odin Sphere to be pretty frustrating at some parts due to the difficulty.

Not to the point of quiting, but definitely way past the cursing line.

And a couple of the stars in Mario Galaxy, more specifically the comet stars, had me pretty close to throwing the Wii Remote.