In any game? I've played Zelda III and Super Mario World, and Star Fox 64 almost annually since release, so those, but I have no idea how many hours. I'm sure some arcade games or shmups would be up there as well, but no idea.
In one playthrough?
180-90 something hours in Xenoblade Chronicles X.
Demons' and Dark Souls are the only other 100+ I can clock in one playthrough.
FFXV (90+ saving post-game for after DLC releases) and BotW (@ 70+ as of this afternoon.)
Some of y'all are animals! I don't platinum or 100% games though, so maybe that's why? My multiplayer game clocks are pretty obnoxious though.
I think I spent about 130 hours in Dragon's Dogma in total, which is by far the most time I've ever spent with a game. Next closest would be Demon's Souls with about 100 cumulative hours, and then after that would probably be Final Fantasy VII with I expect something like 80-90 hours across three playthroughs.
I've sunk far more time into the Elder Scrolls and Final Fantasy as series than maybe anything else hobby wise. I've purchased and bought most of the games more then once and played through them all multiple times, the way they work in general provides a lot of opportunity for replayability.
I'm honestly not sure if it would be a TES game or an FF game though.
If I were to include multiplayer games the easy answer would be Ultima Online.
In terms of just amount of time spent getting from start to finish in one playthrough, Breath of the Wild was about 115 hours for me, which is probably the most. I don't normally spend that much time on single-player games, at least not in a single playthrough. My previous highest time was 80 hours on FFXV.
I must have put, at least, 400 hours combined into Pokémon Red and Yellow back in the day. I would even say I got 500 easily. I put around 30 or so hours into them every few years, so the count keeps rising.
Diablo II: Lord of Destruction has to be around 400 as well. I played mostly solo, but did team up with a few friends from time to time.
Age of Empires II: The Conquerors has to be around 300 hours or so too. Mind you, I rarely, if ever, played multiplayer.
Diablo III nears the 200-250 hours easily as well.
Most recently, per Steam:
OG Skyrim: 185 hours.
Fallout: New Vegas: 140 hours.
Clicker Heroes: 130 (around 129 idling, I guess)
Dark Souls: 122 hours.
Borderlands 2: 119 hours.
Borderlands: 99 hours.
Dark Souls 3: 98 hours (I still haven't touched the DLC).
HITMAN: 93 hours.
Mafia II: 86 hours.
MGSV: 82 hours.
All of those in single player. I really don't like playing with others
I'll never know for certain how much of my life was put into Resident Evil 4 or Final Fantasy VII, but I'm willing to guess it's easily 500 hours each. Even that seems low, knowing that I have close to 200 hours in The Evil Within between PS4 and PC, and I still don't know that game as well as the other two. Somehow.
The longest recorded total playtime I have available to me on Steam is Dragon Age: Origins at 109 hours. It seems laughably low by comparison.
But I'm also one of those people who only buys maybe 5-10 games a year and only really truly loves one or two of them per year, so take that for what you will.