A guy has been unofficially patching the game since release. That's like, 4 years worth of patching. With his work, the game is almost totally bug free, many animations are fixed, some dialog was recovered, textures were improved and A LOT of lost art assets that didn't make the final release were found and restored.
If you haven't revisited the game with his patches, you really should.
Link please

?
As far as what I'm looking for, I dunno I enjoy most genres, except puzzle games which I don't really get. I like games with a really solid story/mood/world. Ironically, most of those for me have been non-RPGs

. Usually I don't enjoy RPGs, because it always feels like a repetitive grind with ****ty combat (compared to FPSes), but if I came across one with a super engaging story (beyond the whole SAVE THE UNIVERSE typical bs) then I'd be up for it. I guess if I came across an RPG that felt like a really good adventure novel I'd be all over it. In general though, I find games where you aren't making the choices suck me in far more than one where I can have a bunch of bland dialog options.
An example would be Dungeon Keeper 2 I guess. The story isn't amazing, but the world and the narrator IS, and it definitely had me totally absorbed until the finish. Thief series is another example, ****ing epic all the way. I felt so much more immersed in that world than any RPG even though I wasn't having clever conversations with guards (lol).
I think I'll have to go pick up a copy of Deus Ex. I never did play that one.