Depends on the game and the person playing it. I agree with Montana on most points. I adore a good story, but as you can see it isn't nessacary. If people can be content with the story in Kingdom Hearts. Good for them.
Every person wants something different. Differences will cater to different audiences.
(ex. I loved the politics in FF12, but laughed at the simplicity of Kingdom Hearts.)