I have to say that I believe gore has replaced a lot of what used to be scary in movies. It seems the more gore the better in Hollywood these days. I remember a time when movies used suspense and fright to accomplish what now has been replaced with gore.
I believe with fontgeek gore has it's place, if it goes along with the storyline then use it if needed. Like telling a true story or something along that line. But I think it is overused today in Hollywood, it seems that every horror flick has gore in it. Or with remakes same thing, overuse of gore.
Now to use gore in a home haunt, I think you would need to feel out what type of neighborhood you live in. If you have a large amount of small children, then cater to their needs which would mean no gore. If it's mainly teens and adults then go ahead and have some things that make people turn their heads. I would suggest to use it in moderation, don't overdo it. The main thing I'm trying to say here, is that gore is not scary. It is designed for one purpose only and that is SHOCK VALUE!!!!
I like a good scare, but I like to use my imagination, I like the suspense that builds up from not knowing whats around the corner. Let me anticipate whats lurking behind the curtain, let me guess who's going to jump out at me from behind the door. I don't need gore to be scared, just let me jump out at someone from behind something in the dark and say BOO!