I just got my PS2 working again, and I'm planning on getting some games for it, so I'm happy to find this thread here, since I forgot about a lot of good games from back in the day.
One game that I'm really fond of is Indigo Prophecy. Great game.
I disagree. Indigo Prophecy/Fahrenheit is an "interactive" story with very little real gameplay. It's maybe good for one or two playthroughs, but that's it. Also, the story itself is completely insane.