The biggest emotional resonance for me was the first Gabriel Knight - Sins of the Fathers. I still have memories of the scene where Wolfgang dies. Amazing game and I feel blessed that I had the opportunity to play games like these as a child.
These games would be such good material for feature films. With Hollywood so completely out of ideas and the huge popularity of occult horror I'm surprised it hasn't been done yet.