Check out Betrayal at House on the Hill. I played it with some friends and it was a blast, a little complicated at first but once you get it things can get crazy fast. It leaves an impression, I remember one guy becoming the betrayer and we had to race to try and get the spirit's bones and bury them before he could summon it. He ended up summoning the ghost but we were able to exorcise the spirit before he could gain control. It was tense at the end for sure...
Oh yeah, Wil Wheaton played it on his Table Top show.