I've been recently been thinking about Arkane Studio's Prey which is a immersive sim, with a pretty good rogue like dlc, that probably has one of the strongest hooks of any game I've played. If you liked Halflife, System Shock, or Deus Ex it's definitely worth a play.
Are there any titles that might not have been commercially successful that you feel everyone should give a shot?
I almost gave up in the beginning because I had never played a game that relied so much on hand to hand combat. I'm so glad I pushed through.