Maniac mansion on NES is my favorite based solely on the merit of it being my first adventure experience. As for new games in the genre, I thoroughly enjoyed The Cronela's mansion demo, and can't wait for the full release.
https://youtu.be/ppKDqNIALyA