So... This isn't really a planned moment in the game, more like a glitch... but it's still EXTREMELY memorable to me.
You know how Darknuts in Twilight Princess kick Link when he comes to close to them without dealing any damage? Well, I was fighting those two Darknuts in Hyrule Castle. I was targeting one of them, and I don't know EXACTLY what I did, but somehow, they got at just the right distance apart that when I got close to one of them, it kicked me right into the other one. ...And then that one kicked me right back. And then I was just sitting there watching in awe as Link was constantly kicked back and forth between these two Darknuts.
It was the funniest thing I'd ever seen in my life. And I knew I had to get it on camera, so I dropped the controller to grab my phone and get my sister to see -- but then that caused me to let go of the Z button and stop targeting, so they stopped kicking me back and forth. But that moment will still live on in my memory forever.
There are other moments, too, now that I think of them, but I don't think I should go into detail on ALL of them. This would be an extremely long post if I did.
I think beating Thunderbird would be at the top of that list, though. I was so excited that I tried running out of the room with the 3DS in hand, but it was pulled back because it was plugged into the charger in the wall, plus I had headphones in. All of those cords were torn out and it was flung behind the laundry basket. Plus I was shaking so badly, I was so immensely excited. Another moment where I shook from excitement was beating the full Skyward Sword Lightning Round in Hero Mode with only one heart left. That was a real accomplishment; I'd been trying to finish that for SUCH a long time, and to actually do it was an amazing feeling.