I will fully admit certain games are hard. Zelda 2: Adventure of Link, Mario 2: The Lost Levels, Castlevania III, Ghosts 'n Goblins, UN Squadron, Uniracers, Super Empire Strikes Back, Shadows of the Empire, F-Zero GX, Ikaruga. Heck, even the recent title Little King's Story on the Wii gave me a ton of trouble due to the way it controlled and its lack of information of what to do to defeat bosses.
Resident Evil 4....not so much. Yeah, I died a few times. But after learning a monsters patterns or figuring out what I needed to do with a quick time event, it was rather easy. Most of the 'hard' parts in Resident Evil 4 came from the 'cinematic effects' and not understanding what you needed to do to avoid getting hit. Something the Resident Evil series is known for and actually, Resident Evil 4 had a lot less of.
Six upcoming games you should look into:
