One game often considered to have a very long story is 'The Elder Scrolls V: Skyrim'. It has a vast and detailed world filled with numerous quests, backstories for characters, and a complex main plot that can keep players engaged for a long time.
Another game with a long story is 'The Witcher 3: Wild Hunt'. The game's main story is long, but on top of that, there are a huge number of side quests, each with its own story arc. These side quests often tie into the main story and expand the world and lore of the game. Geralt's journey across the Continent is filled with political intrigue, monster - slaying, and personal discovery, all of which contribute to a very long and engaging story.
Well, 'Final Fantasy VII' also has an incredibly long story. There are multiple discs for the original release, which shows how much content it has. It has a deep and convoluted plot involving a battle against an evil corporation, a hero's journey, and lots of side - stories and character development that together make it a very long - story - heavy game.