Well since I mentioned Sanitarium and Harvester, I'll go ahead and mention these games from this series in keeping with the horror themed ones. Wasn't sure if they qualified at first, but apparently they're still classified as point and click adventure even if they aren't in the traditional sense of what Sierra and Lucasarts was doing.
The Horrorsoft Series
Okay there's 4 of these games. Two of which were directly connected to the Elvira Mistress of the Dark brand, and one that just sort of got a picture of her slapped on the box in later editions of it (when they acquired the rights presumably) and the last game which didn't have the brand anymore.
In all games there's certainly a lot of pointing and clicking and adventure of trying to solve some puzzles and such, but the later ones have more of a fighting or sometimes even RPG element in them.
The first one Personal Nightmare is probably the more complex one since it still contains a parser in addition to pointing and clicking with a mouse. (Like old Sierra games) In fact you'll probably have to use the parser sometimes since not everything is necessarily readily clickable until you're delving a little deeper into examining shit via the parser. Basic premise is your dad, the small town preacher died and you're there to figure out things. Doesn't really explain much in the game itself what you're supposed to be doing, but the goal is to stop the evil that has infiltrated the town.
It's probably the creepiest of the bunch probably because there's no fighting element in it, no music and it's a small English town that just feels "off". It doesn't have the same graphics as the other three games and is more puzzle based. There's a few times where you have to figure out how to get past a monster, but again it's always puzzle/item based, fuck it up and you'll instantly die. You get close up shots of your death too, so that's cool. Bad thing is there's a time limit and time is always marching on (Day and Night cycle) and sometimes you have to figure out where to be and when to get stuff at the right time.
The second game is Elvira Mistress of the Dark and it basically takes place in a castle she's inherited and she needs you to get rid of the curse on it along with killing a lot of the bad things infesting the place. This is the one that introduces a not so great fighting element to it, though it's also got a crafting element that lets you create spells, both necessary to overcome certain puzzle and to make fighting easier at times. This one is also the one that packed in a lot of gory death scenes, so even if you get killed, you get something cool to look at.
Third game is Elvira 2: Jaws of Cerberus. Basically you're helping Elvira in a haunted horror studio this time around. You have to track her down first (On one of the three horror sets and it's ALWAYS the last one) This one ramped up the fighting and RPG elements, but I don't think that was a good direction since the fighting in these games isn't the best. Even that wouldn't be so bad if they hadn't included FUCKING MAZES in two of the horror sets.
When you finally rescue her, you still have to escape the studio which you can't because Cerberus is guarding the exit gate, so you'll need all the right spells and equipment to defeat him too. Despite being annoyed with bad fighting and mazes, I still played it a lot since the ramped up the bloody deaths.
Finally the last game was Waxworks (Which a lot of people just call the unofficial 3rd Elvira game due to looking like the others) This one pulled back a bit on the RPG element, though it's still there with the stats. This one has sort of convoluted plot of being a good twin and having to go back in time to stop all the evil twins that have caused trouble at various points to break the family curse. These include Ancient Egypt, Medieval Transylvania, Victorian London and some industrial period mine (Probably America).
You go back in time using a waxworks display, accomplish your goal and you get transported back to the present day waxwork museum to go to another display. So it's basically 4 separate areas that you can do in any order since none require objects for the others. Two of the displays have the more unfortunate combat elements, these are Transylvania where you're mostly fighting zombies and the industrial mine where you're fighting plant people. There's still puzzle elements, but it's mainly all set up to kill the evil twin in those time periods.
London has less fighting, but a whole lot more running since the evil twin in this case is Jack the Ripper (So there's cops and lynch mobs wandering about thinking you're the killer and they'll hang or beat you to death instantly) Ancient Egypt as you might expect has the most puzzles seeing as its all about getting past traps and such. Waxworks probably has the most cool deaths out of all four games. There's so much variety in how you can die that they probably realized that you'd be seeing those death screens often anyway.
Well there's 4 more for you to look into if you so desire. I'll probably remember more and post those at some point.
