It's an issue that must be applied on a game-by-game basis. Some games work with no or next to no story, some games work with a fully involved cinematic story, and some games need something different to work, or at least to be truly excellent.
Ultimately, no, games don't need stories, but certain types benefit greatly, as long as the story is properly applied.
Monster Hunter: pissing me off since 2010.