For this specific gen, I would have to say that the ending of Red Dead Redemption was my favourite and best remembered moment in gaming.
When I stepped out of that barn, my game bugged. There were a solid 30 seconds in which I stood there, finger hovering over the trigger button, thinking how the hell am I going to get out of this situation. When I finally got to shoot, taking something like 4 of the guys down, I could do nothing but sit and watch John get riddled with bullets while thinking 'S**t, I messed up'. I got so attached to that character that It was just pure shock and awe. Brilliant.
That being said, the ending of Bioshock Infinite left my jaw on the ground. Going to have to add that moment into this reply - just to epic for words.
I loved all 3 of the fable games (I am NOT going to count journey). I don't understand all the hate that Fable 3 gets though. The ending was pretty rubbish, I'll give you that, but I certainly enjoyed the experience for what it was. The game sure could have used some more development time, the whole time I was playing it I couldn't help but think that here was a game that fell short of epic, with all this little screw ups and poor decisions that ultimately left it a bit lack-lustre.
I'm over the moon about the Anniversary edition though, cab't wait to get my hands on it
Kynsgrove happens first while you are proving your worth to Delphine. later on though If you choose to accompany Esbern and Delphine to Sky Haven temple you will witness another dragon resurrection outside Rorikstead. That's the attack I mean, and even then your right in saying that all that occurs is a few townsfolk run about.
It has been a long while since I last played through the main quest, but if memory serves me right, isn't there a mission in which you save Rorikstead from a dragon? Even so, they could have added in a bit more destruction on the Dragons behalf... Im thinking burning houses and more innocent villagers being swung through the air from the jaws of a dragon.
They just needed to show more evidence of the destruction that the dragons could have reaped upon Nord villages and also how much of an advantage they had over those people who were unable to harness the power of the Thu'um. I don't know if it was just me, or the fact that there was a civil war going on, but it just seemed as though a lot of the holds were remarkably well prepared for dragon attacks considering the fact that until Helgen was destroyed, most tales involving dragons had dissolved into myth and legend.