Alien Isolation is the one that just came out and it was one of the most unique experiences I've had in years. I was very frustrated at first. I was running around trying to escape the Alien and no matter what I did, he'd catch me and kill me. I was ready to give up on the game. Once I learned how to quietly sneak around and use the Alien to my advantage (to kill the evil humans), it became a blast and so rewarding.
Oh man, Alien Isolation is easily my favorite game of 2014. Admittedly, I am biased because of my undying love of the film, but I have NEVER been so scared playing a game in my life. The feeling of tension and terror was so strong in that game.
A lot of reviews claimed you'd sit and wait forever for the alien to leave, and while I found you certainly COULD hide under a table for 5-10 minutes if you wanted to, sooner or later you'd just have to make a break for it. Every time I'd be whispering to myself, "please don't see me, please don't see me..." and even saving was a harrowing experience at times. I also agree that using the alien to your advantage is incredibly satisfying.
I loved every second of that game, and there is one sequence (I won't spoil it) that ranks as one of my all-time favorite gaming memories. Just remember that Isolation is a PURE stealth game. If you go into it with that expectation (and you like that style of game), you'll most likely enjoy it.