That One Boss:
Rollout. Need I say more?
Yeah, Whitney and her friggin Miltank.
Benezia in
Mass Effect before you figure out how to avoid the Stasis bug. Works best with Soldiers because you're doing stupid run-and-gun Immunity tanking anyway.
France in
Europa Universalis III, before HttT. Alternatively, in Asia, the Ming or Timurids.
The Space Jump spider in
Metroid Fusion. To a lesser degree, the second appearance of the Security Robot, and "Nightmare".
Mobius One -the player-character from
Ace Combat 04: Shattered Skies - in Gauntlet mode in
Ace Combat Zero: The Belkan War.
That One Level:
Anything involving krogan on Insanity in
Mass Effect. Anything involving Collectors (or Husks, depending on your class) on Insanity in
Mass Effect 2. The final fight around the locked door on the exterior of the Shadow Broker's ship in
Mass Effect 2 DLC.
Every stealth level in every James Bond game ever.
Xen.
technically not "a" level, but whatever
Yoshi's Canyon in
Mario Kart 64.
Fighting on the Moon as the USSR in
Red Alert 2: Yuri's Revenge. Serious case of Xen Syndrome with most of the USSR missions in that campaign in general. Slightly less so with the Allies, who have the supreme advantage of prism tanks.
"We Don't Go to Ravenholm..." in
Half-Life 2. On harder difficulty levels, Entanglement also applies.
The last few levels of
Call of Duty 4: Modern Warfare. Especially annoying after the first couple of levels in the final chapter, which were arguably some of the best in the game.
On a similar note, the Reichstag interior in
Call of Duty: World at War. Actually, all
Call of Duty campaigns on high difficulty levels, because they just end up being stupid grenadefests.
The Library in
Halo: CE, Sacred Icon in
Halo 2, and Cortana in
Halo 3. Essentially the same level, reincarnated. The Library in particular killed all of my enthusiasm for the first game. Sacred Icon and its younger brother High Charity had the supreme advantage of being short like all of the
Halo 2 levels.
All levels with Stonehenge (Safe Return, Tango Line, Stonehenge Offensive) in
Ace Combat 04: Shattered Skies. And Megalith, too, for good measure.