Play Baldur's Gate 3, one of the two newest Zelda games, or Elden Ring without a walkthrough. You can still get this feeling, but due to economics, you're unlikely to find it in big expensive games anywhere near as often anymore. Smaller indie games can experiment more with this sort of thing. But basically, it's still out there.