Adventure games! Like real adventure games.
Very few games have filled this niche for me. Skyrim, Zelda and Fable 2 come to mind but not much else. Two of those games kind of done it by accindent
Adventure FPS.
Metroid 3, Bioshock to an extent... very little else comes to mind