It depends on the specific game and its design. Some games might offer a mode focused solely on the story, but others might not.
Well, usually it's not that simple. Sometimes games prioritize a balanced experience of gameplay and story. You'd have to check the game's features or reviews to see if there's a pure story-play option.