The entire skyworm battle in Shadow of the Colossus, I think it was like #13 or something, the one where you have to ride your horse along side its fin as it drags through the sand kicking up this enormous amount of dust so you can barely see, and you're standing on top of your horse galloping at full speed with this huge bombastic epic score in the background, then you have to jump and you are dangling there by one arm and have to wrench yourself up. it was literally the most exciting gaming experience I've ever had.
another moment late in that game, was right before I was going to fight the final colossus, I was riding Agro to where I thought the boss was, and stopped along the way to climb a tree and get some fruit. when I came down from the tree, Agro was gone. I found him drinking from a nearby pool of water. I went up and petted him. Then got on him and rode to the Boss, absolutely having no idea what to expect of the final Colossus.
what a brilliant game.