Vampire: the Masquerade - Bloodlines. Dated, needs mods to run, but the fact that there's still a community patch being made for it after all this time says a lot. Haven't really heard much about it since the sequel crashed and burned, which is sad because no game has really given me the same atmospheric vibes. It was (is?) really special
Katamari Damacy?