Seriously. Why spend $50 to watch a video game when you can spend $5 to watch a real movie? It simply doesn't make sense.
NSMBWii has an exrtremely weak story (I mean, it's just save the princess like it's always been), but the gameplay is so great that it doesn't matter.
Battlefield doesn't have a story at all (at least the older ones didn't), but the gameplay is so epic it doesn't need one.
These two examples show how games should be. Now lets take CoD:MWR as an example. The single player campaign got old fast because the story was filled with cheese. I quit playing the single player campaign because I got tired of the story and the extended cut scenes. I quit playing the single player campaign of WaW all together solely because of the story.
There have only been two games that I've played where the story enhanced the game, and both of those came out in the 90s.