Trackmania 2020. Great example of a game that is simple in concept but super deep in skills that you can both play super casually at your own pace or super competitively. Plus there is a great community and endless content to play.

Minecraft...

L4D2. built a new computer for that game specifically after loving L4D. super fun arcade shooter that will never be uninstalled from my computer.

lol the problem with Destiny is they turned it into a treadmill and stopped putting the work into character and level design.

Elden Ring can easily take more than 100 hours on your first playthrough, and different builds significantly change your play style.

BG3, similar deal. Subsequent playthroughs are probably going to be accelerated, but there are a bunch of different story choices you can make that feel different, the party members have their own story lines, there's a special custom character called Dark Urge that's intended for a later playthrough that has it's own twist, and you can change the strategy of encounters a lot with different party constructions.

Rimworld calls itself a story generator because you're going to fail and have people die and whatever, but every game plays out different, there are a good couple scenarios, and there's expansions and mods you can add on top of that for variety.

Just the first couple that come to mind. I'm not near 1000 hours on any of them, but they all have a lot of content.

The Binding of Isaac

Kerbal Space Program

I’m well above a thousand hours on the first game. Then all my flying sims (MSFS, Xplane, DCS, Elite Dangerous) also have a very high hour count. But for civilian airliners most of those hours are spent AFK in cruise.

Rocket League

Stellaris

The Binding of Isaac

Guild Wars 2, so far I put 4,800+ hours into it.

I like that it has so many kinds of solo and group content that I can just do whatever I'm in the mood for that day.

Apart from Flight Simulator 2020 and DCS, I absolutely love games like Euro Truk Simulator 2 and Snowrunner. I put ungodly amounts of hours into those. Especially ETS 2 is incredibly relaxing. No pressure, just a lovely drive. It’s definitely not for everyone though.

Team Fortress 2

Path of Exile.

I'd say I'm a fairly mid-tier player, get better with each season I play, the breadth of mechanics and depth of complexity is mind breaking. I've only played like 2000 hours though, I'll get it all figured out eventually... Right?

Dark Age of Camelot

Don't Starve Together scratches the MMO itch for me. It's not an MMO, but there are public servers where you can hop in and hang out, raid bosses and whatnot. I have ~4k hours in it now.

Factorio, Warframe, Minecraft, Dota 2. However, the only two I'd still recommend are Factorio and Minecraft. Warframe's grind seems to have finally burned me out for good, Dota 2 is bad. You're not gonna have fun with Dota 2. The game concept is good, but like most competitive online games, the community fucking sucks.

In addition to Factorio and Minecraft, try Voices of the Void, The Long Drive, WEBFISHING, and Balatro.

Edit: oh yeah, and personally I have both Sims 2 and Sims 4 w/ all DLC (yeah, I toootally bought all the dlc) installed on my steam deck. Both fun games with their own ups and downs. Sims 2 is great vanilla, Sims 4 is great when heavily modded. Don't bother downloading the F2P version of Sims 4 from Origin if you're wanting to mod it with stuff like sacrificial's mods. Those'll break with every major update (and sometimes minor updates too!) and you can't pause updates anymore. So, you'll have to find alternative methods.

Slay the Spire

If it clicks with you Monster Hunter (World+Iceborne’s a good starting point) can easily eat up hundreds of hours of your time grinding and doing endgame content, especially if you have a group to play with.

Mine are:

Any Fallout or Elder Scrolls

Diablo 2 or 3

Stardew Valley

Borderlands 2

And I never consider it a real game, but I do sink the most hours in Hearthstone. I've been playing it almost daily for the past ten years.

Rimworld, and Football Manager (although they last one I played is 2020)

I don't think I've ever played a game more than 200 or 300 hours.

Why do they have to be 1000 hours? If you’re getting gaming fatigue you’re not going to fix that by sticking to the same genres you always play. Go onto Steam/gog/eshop/etc during the Black Friday sales next week and buy a big pile of 40 hour games for $3 each

(Mine is FFXIV, to answer your question)

Minecraft. Probably have around 5000+ hours I think. Playing since I was 10(now 17). So, many wasted hours on Anarchy Servers and Ranked Bedwars.

Morrowind. Although it's more like play a few hundred hours every five years for me.

Final Fantasy XI. I'm almost exactly 1,000 hours into it, and only halfway through the storyline. I haven't even touched end-game content. I'm playing on a free private server called HorizonXI that is well-populated and feels more like the game when it came out versus the modern day solo experience.

Somehow ctrl+f failed to find this one, but Path of Exile is probably my drug of choice there. While I raked in 1k hrs with Dota2, I'm not sure I"d recommend it unless you really want to sell your soul to MOBA life. And it's not quite to 1k yet, but honorable mention must go to Satisfactory as it's well on its way to being game #3 in the 1k+ list with me.

Regarding the question itself, Starbound and Minecraft. Maybe Final Fantasy XII if I was to play it multiple times, as I take at the very least 100+ hours to finished it, and 250+ if I'm not in a hurry.

But regarding gaming fatigue, perhaps it could be a symptom of playing too much of only a handful of game styles? If you wouldn't mind, may I suggest to check some smaller games in length and scope, specially indies? Those tend to be rather diverse in their scopes and executions.

If you like space games, X3 and X4 can probably eat up lots and lots of your time. Space Engineers if you're less interested in flying, space economics and creating a supply chain (which X lets you) and more in gathering materials and creating all sorts of weird, funny or actually amazing stuff. SE is probably better played with at least 1 other person, possibly more, while X is exclusively single player.

Grand Strategy games can also obliterate your free time. Civilization 5, any Total War game. Hell, Age of Empires 2 can have very long matches if you play on huge maps and people have loved that game for over 20 years.

You can also go for Fallout 4 or Skyrim with extra content mods, like dungeons, quests or areas.

Personally, I'm just past 400h on Palworld, so I'd recommend it as well. I've played from start to "finish" some 4 times by now. Official servers will be wiped sometime in December, possibly with a new patch arriving, but you can always play single player and even invite a friend to play on your local save and never lose progress (unless the save gets corrupted, which can happen).

Team Fortress 2. There's just so many different ways to play the game with its combination of classes, weapons and game modes!

Minecraft FTL Destiny 2