Arcanum: Of Steamworks and Magic Obscura is a fantastic CRPG. Good luck finding it, but it's deep and hard. And I wouldn't be playing it if there wasn't a "No Gore" option, so give it a try; it's long, deep, open-ended, mature, and loads of geeky fun!
Seconded.
Also be sure that your PS2 library has not overlooked Nocturne.