I’d imagine The Witcher 3 falls into this camp? Maybe Kingdom Come Deliverance 1 & 2 as well? I can’t be incredibly sure, as I haven’t actually played them.

You mentioned Elden Ring, but it’s much more combat focused and less mini-dungeon puzzles. Though fighting a boss can feel like a puzzle sometimes.

Wuthering Waves might fit your bill, but it’s a free to play gacha game so that comes with its own can of worms. It’s also a bit more combat focused that BOTW and ranged combat + gadgets don’t really exist.

You may like some of the Assassin’s Creed franchise if you never played that. AC2 was my favorite of those, but it’s been a long time since I touched that franchise.