I think it all comes down to how developers balance out the overall difficulty of their games.
Quite frankly, most of the times, when it comes to a challenge, I rather play an older generation game to most 7th gen game and forward due to most recent games having way too many systems in which you can save your progress or make sure that you don't die, like check points, auto-saves, infinite lives, regenerating health, replaying on part over and over again.
Sometimes it's even worse than the Save State function in emulators, which is a function that's going to be introduced on future PSP firmware, another "cut some slack" to the player technique
As I said, nowadays games are mostly too easy. With the obvious exceptions of games Like Devil May Cry, Persona 3, Geometry Wars, Ninja Gaiden and a few others, the others just don't give enough challenge, except in punctual places like the OP said, which are the parts that I enjoy the most in actual games.
Coming from the Ghost and Goblins, Battletoads, Double Dragon, Contra, Shinobi, Ninja Gaiden, Golden Axe, Streets of Rage, Dragon Quest, heck, even Super Mario Bros 2 was more difficult than almost all nowadays games combined, you can see why I enjoy challenging games and challenging parts of a game and don't find them frustrating at all.
Current PC Build
CPU - i7 8700K 3.7 GHz (4.7 GHz turbo) 6 cores OC'd to 5.2 GHz with Watercooling (Hydro Series H110i) | MB - Gigabyte Z370 HD3P ATX | Gigabyte GTX 1080ti Gaming OC BLACK 11G (1657 MHz Boost Core / 11010 MHz Memory) | RAM - Corsair DIMM 32GB DDR4, 2400 MHz | PSU - Corsair CX650M (80+ Bronze) 650W | Audio - Asus Essence STX II 7.1 | Monitor - Samsung U28E590D 4K UHD, Freesync, 1 ms, 60 Hz, 28"