I played the first remake for like 20 minutes once. I didn't feel like the ability to walk off of cliffs by misclicking or sometimes having a monster randomly slowly walk towards me added any sense of danger to the game.
I played the original Space Quest until I walked into a room and was shot to death immediately.
The only Sierra adventure game I have ever actually completed was Shivers 2. I enjoyed it but there were very few places you could actually die, iirc.
Also, it's not exactly a Sierra game, but I've played Hugo 3: Jungle of Doom to completion.
Though, to be honest, I don't see how any of this makes a difference, because I spend probably more time than any other human on earth thinking about game design and mechanics, and manual save is nice to be able to do, but I really don't see how a game automatically saving after you complete some large task is anything but a convenience.
Also, the "being mad at yourself vs being mad at the game" argument does not work for me, because I'm mad at the game if it's a cheap death, and mad at myself if it's my fault for being stupid/unskilled, it has nothing to do with who created the most recent save file.