Newbie gaming question for PS3

[DigitalfreakNYC]

OK so I haven't bought a video game system since my parents got me a Super Nintendo when I was a kid and now I've been playing the Lego games on my PS3 and I'm addicted again.

Here's my question:

I used to always love to play adventure/role-playing games on my PC when I was younger and preferred them to action games like Castlevania/Contra etc.

I loved Maniac Mansion, Monkey Island, the adventure version of Indiana Jones and the Last Crusade, etc etc. Anything where you could pick up items, talk to people, ask questions, use items, etc.

Is there anything comparable on the PS3 to get? It seems like all the games are heavy action/war/racing games.

And if not, what should I look for on a PC if I've been out of the gaming loop for more than a decade?

THanks all!