I'll second (or whatever) Pathologic, The Void, and Demonophobia, even if they have nothing to do with role playing games.
If you can stomach japanese (and anime like) stuff, and having as much as those previous ones to do with playing roles, give Chäos;Head (also known as Chäos;Head Noah) a wirl. A quick way to describe it would be to call it Mindfuck: The Game and leave it be. While the opening videos (
XBox,
PC,
PSP) may have it appear like a harem dating sim with action elements it has no dating sim, no ero, no hentai, no action, and no harem elements at all. It has, however, the most pathetic main character to ever grace gaming (japanese or otherwise), a wide range of wrong-in-the-head characters, and a very long and unique plot that will give you a hard time separating what really happened from what the characters deluded themselves to think was happening even after finishing it. If you know enough about this to recognize 5pb and Nitro+ names you already know the production values and writing are pretty much ace.
If you are interested but lack the google skills to find the translation patch or the game by yourself send me a PM.
And since we are at it give Yume Nikki, The Mirror Lied, or Downfall a wirl too, if you are into indie stuff. Yume Nikki and The Mirror Lied are adventures (as in, point & click without the pointing and clicking) made in RPGMaker. Downfall is a traditional point & click adventure made in AGS or something similar whose name evades me. The three are completely amazing, but they may be an acquired taste.