In what ways do narrative and storytelling enhance the player experience in video games, and which games are often cited for their exceptional storytelling?

In what ways do narrative and storytelling enhance the player experience in video games, and which games are often cited for their exceptional storytelling?