Earlier quoted context omitted.
There are ~~absolutely~~ fantastic stories in video games. There are plenty of games that you play for the story and the gameplay is just meh.
Such as? Besides adventures games Infocom or Sierra style and their descendants...
And just to make the point: the only games on this list I have played and finished are Portal 2 and The Vanishing of Ethan Carter. The others, I either know of the story because people liked it so much I learned it second-hand, or the gameplay was so boring that I just quit halfway through but I put it on this list for the story anyway.
Edit: I gotta throw Paratopic in here. Played that one through twice, it's less than an hour.