Ok, so this game might not be as obscure as most, I don't know. But it definitely deserves to be mentioned.
You play as a normal bartender in a Dystopian Society. You get strange "nightmares" from some strange monk people who are telling you to kill some people, who are part of a group trying to destroy this "Dreamweb" the monks protect or something.
This game is slighty NSFW, as it shows a sex scene early in the game.
IMO, this is one of the good Point and Click PC games I have played/beaten.