In terms of single player games (as long as you arent put off by the turn based nature) baldur's gate 3 is as good as it gets in 2024
Just a throwback to when AAA games were actual passion projects with so much effort and detail put into the world
So much random stuff to discover, actual choice (not the bethesda special that everyone does nowerdays where you get to click but the outcome is the same anyways) and a genuinely good implementation of a ton of dnd mechanics
Edits:
Webbed: Spider web swinging game. 10/10 mechanics. Shit is what people think they played when they gush about spiderman 2's swinging mechanics. Very short (7-11 hours id say to 100% it) and doesnt have a big story, but does well to let you explore a fun little world and interact with the various insects
Crystal Project: a classic JRPG but with focus on exploration (uses platforming a ton). Semi long (50 hours to be properly done with it). If you enjoy the old school JRPGs this ones gonna be really fun, otherwise safe to skip
Monster Sanctuary: Pokemon like game, but again good platforming, lots of exploration and refreshing battle system. A bit on the harder side but not to an unfun level. ~30 hours to play through it.
(Noticing a trend of what I play yet? ill mix it up a bit)
Cave Story (+): The classic. You probs already played it but if not ya gotta give it a shot. Pretty good platform shooter that helped elevate indie games to the big stage. 6-12 hours.
Moss: Book 2: If you have VR otherwise cant play this one. Amazing cute little action adventure game. Very short (6-8 hours max) but well polished and one of the best implementations of VR ive played to date.
Any Ori game: Platformers. Youll know this game as soon as you see a screenshot of it. Art if it was a game, and the gameplay isnt bad either. Both semi short... like 12 hours?