Gabriel Knight 3: Blood of the Sacred, Blood of the Damned

I love that game so much!

BTW opensource engine rewrite here (highly recommended):

https://github.com/kromenak/gengine

GK3 was really slept on. Definitely had a vibe entirely on its own, and a sense of time that I found very compelling.

Last year's Blake Manor game also kinda captures that.