Story Based video games end up in a single-player category.
There are many multiplayer games that focus on story, but its a rare gem, overall all singleplayer games are based around the story. The way you progress with your character and the gameplay is by following the main storyline.