My first suggestion is definitely
Telltale's Walking Dead series. It's not a hardcore puzzle adventure game but instead, it's a narrative-driven adventure game with choice and consequence. Definitely some of the best story-driven games out there (especially the first two) and it just feels awesome to witness the character growth of Clementine.
If you want something a bit more old school, I recommend the
Quest for Glory games. They're much harder, gameplay-wise, but they have an extremely charming fantasy world to them which just feels fun to explore.
--- For a more modern version of this style of PnC adventure game, check out
Mage's Initiation: Reign of the Elements. It's extremely similar to QFG but in an original universe focused around magic
While it's technically an isometric RPG, the
Shadowrun Trilogy has a more linear, narrative-driven structure that feels like a combination of QFG-style gameplay and classic Fallout gameplay. Not exactly what you're looking for but they're fantastic and extremely underrated games so I tend to recommend them any chance I get.