I like it, although the tone is somewhat over the top in the horror quotient, IMO. I suppose I forgive it, as it *is* the Halloween season. Overall, a good adventure with a good haunted manor setting. Some intentionally vague spoilers in the blackened text:
The Skinsaw Man: The horror based background and history for this character (pre-Skinsaw conversion) is so overt that it's hard to believe that the characters wouldn't remember all this during Burnt Offerings. I can see it being difficult when PCs ask about the NPC when they first meet him to have them not remember him or that it wouldn't immediately make them suspicious.
The Attic: OK, so the characters enter the house, immediately getting a chance to hear the revenant crying in the attic. If they confront her, she rushes to attack the Skinsaw man. There's even a note that the characters could just follow her to him if they're quick. This doesn't seem unlikely. So what happens? There's no mention at all in the Skinsaw Man encounter about this possibility. In fact, it has a rather long and unlikely scripted scene where he goes all Sybil on them. I have a hard time believing the characters would sit there being the brunt of this for any significant length of time. And I have an even harder time thinking why the author didn't mention what happens when the revenant encounters him.