Haunting Ground
Clock Tower 3
Psychonauts
Great games, if you have a couple hundred bucks to pay for them (I would really like Haunting Ground but $98 is a bit steep for even me).
Most of the RPG Titles I would recommend have been said already. I will add a sort of heads up if you or anyone else decide to try and get all the .hack games... be very wary when dealing with Gamestop. They have a bad habit of filing both .hack and .hack//GU under just ".hack". I had probably 4 occasions when trying to track all those down where I would get .hack Vol 3 inside the case for .hack//GU Vol 3 which is what I had actually ordered. It can become a real frustrating process if you are ordering from the online store, losing out on 3-5 bucks shipping each time you have to return that crap for a refund.
I will also say this, if you are a fan at all of Silent Hill the best thing about having a PS2 is being able to play the PS2 versions of Silent Hill 2 and 3. They are expensive on PS2 now and the main reason is that the HD release on PS3/360 was complete *** garbage. They really just did a horrible job and for a HD release the game actually looks worse, I mean for *** sake they took out the fog effects for 85% of the games. There is a long section of Silent Hill 2 where there should be a siren going off in order to build a feeling of suspense (remember the siren from the movie?) and they just up and forgot to put it in the HD version, GOOD WORK GUYS!