Well, there is a lot of bashing to games like MGS4, though I think its story is good(and the game is one of the best I have played), some fans certainly make it look like its something from another world, thats why I think it also gets bashed.
I like stories in games like ICO and shadow of the colossus where I ask myself what is the game story and when things are clear to me in the end. The game pushes you to feel interested in what is happening and why.
I also like stories in games like Folklore too, more narrative.
In the end what makes us think that the videogame stries are better than theones in movies or books is the amount of time we get in the characters place or "live" with them, we get more emotionally attached.
This added to music that is something books cant have, enhaces the amount of emotion and makes average or OK stories feel like they were better than any book out there.
Anyway, sometimes is good to get involved and sometime we enjoy just sitting and listening to the story the game creator prepared for us, with all its atmosphere(graphics, sound, music, VA).