I'd like to say The Evil Within, save for the DLC screwing the original plot of the game and some small questionable gaming design here and there. Still a masterpiece in my eyes.
But if I were to say a game that fits into OP's description, the last great, unforgettable game I played was Dragon's Dogma.







