How blockbuster games are written is a look at how narrative design is used create the plot of AAA games.
A great story can carry a poor game and a bad story can destroy a good game. Take for example Portal which is a fairly standard puzzle game but the story lifts it to a whole new level.
There are plenty of great games out there with great stories, often you find them in the last place you look. However, you could start here.