You can't die in any of the LucasArts adventure games. (Well only in the 1st Monkey Island game if you try really really hard you can get yourself into a position where you can't get any further
) So I'd definitely recommend those to you.
Simon the Sorcerer I & II.
The new Sam & Max episodic games are pretty cool too, but personally I find them just a little bit too easy...