I really enjoy this trope. The "Zelda Ocarina of Time if it were a modern game" series has the MGS style discussion, and the whole series is incredible.
Here is the forest temple video which is a short sample of what to expect: https://youtu.be/KC656o7_zVk
The game 'UnMetal' takes this trope as far as it can be taken. https://store.steampowered.com/app/1203710/UnMetal/
It's probably a bit too far, but nevertheless enjoyable for the comedic effect.