Folks act like it's such a blessing/punishment that Duck Hunt is in Smash Bros...

Honestly, if you want REALLY mocking failure sequences, try playing "hardcore" games from the 80s and 90s, or Sierra games, either category going out of it's way to creatively rub your mistakes and failures in your face.

The first category would basically take 20 or 30 seconds to force you watch your character die horribly and then force you look at a fancy and "HAHA YOU DIED biggrin " sort of game over screen with mocking music and totally evil and noncomical laughter as you might expect from a demonic or otherwise scary movie.

Sierra had an especially big deathboner for it's protagonists and had loads of creative or morbidly joking ways to kill them the absolute moment you did anything even slightly outside the game's narrative.