Super Ghouls and Ghosts.
By far.
I feel bad for the poor guy.
F-Zero GX
Elmo's Number Journey.
Very poorly designed.
Battletoads is pretty hard...
The original Rune Factory is pretty damn hard.
Mafia is hard if people expect you to be good because they vote you out right away if that's the case