Have to go with the lucasarts and sierra ones. Your monkey islands and maniac mansions.
I love Indy fate of atlantis.
Darkseed I thought was good but can't seem to do it these days.
I liked KGB thought it was very atmospheric but impossible to complete without a walkthrough.
I think the sierra games had some good stories but didn't like the dying restart aspect of it.