Everyone already mentioned Dark Souls and stuff like that. Some stages in classic Doom are also kinda like that.
But my personal nemesis is the mission Glatisant in Ace Combat Zero. Every AC game has it's long score attack missions, but Glatisant is mandatory in every run of a game you have to clear at least 3 times, and it's a 30 minute long ground assault on a snowy mountain range with poor visibility and covered in air defenses. The danger level never gets lower, and it's easy to get shot down right at the end and having to start it all over again.