I understand what Yahtzee is getting at. I mean, think about it. What makes these scenes in The Lost Crusade and the like more impressive than anything we've seen in recent media? The answer is just like Yahtzee said: it's classic one-upmanship. It's like some one is proclaiming, "O Ya! Itz ubar-epic!!!!111! Leet haxxors!!! let me tries!" They don't really know why it's epic. They don't even try to understand; they just know it is and for that reason, they try make up the rough equivalent of their own digital penis and try measuring up.
We, on the other hand, are treating to a spectacle that is, in a metaphorical sense, the guy watching one man successfully perform an impressive feat along the lines of jumping five people on a bicycle without landing on any of them. He'll think he can do that, no problem! He has the intellect level of at least a fifth grader and the ability to ride a bicycle! So he'll try to jump seven people and of course, the whole event will leave his fragile male pride in a similar state as the broken bones of some of his poor hospitalized jumpees.
His failing point is that he didn't stop to think that maybe the reason WHY the first guy succeeded was because he practiced, and even then, no one likes a copycat. We'll sympathize with those hurt, but we feel nothing towards the idiot, if not some measure of scorn.
The main reason why these 'smaller' instances impress is because they deliver the kind of tension that drives us crazy. Yahtzee's hobo had him at an inch of his life, yet that God of War monster was already up against an even worse monster: Kratos. Even if they make these large monsters, unless you deliver some kind of tension, give us reason to perceive them as an overwhelming threat, the only response they merit is, "Okay. And?"
In Indiana Jones case, in relating to the tank, we feel tension because he's on the verge of suffering the same fate as a JRPG in Yahtzee's possession: to be flattened, tossed aside, and maybe shot full of holes, if Yahtzee and the Nazis have the time. It's why the whole event is remembered so clearly.
In the end, it's important not to try to show other people up, especially since other people's opinions are so subjective. If you want to produce something to impress people, try to forget everything you ever once thought of as epic and think of something you can do and focus on that. Don't be the guy who shattered four clavicles (yes, I know what a clavicle is) and two pelvic bones.