It's not the greatest flick, but it didn't suck, either. Not a bad friday night Thai take-out and beers movie. I usually pick up on stuff pretty quick but this one had me fooled.
Not completely a "haunted house" flick, but The Village had somewhat of the twist you're looking for.
I'll probably think of others, but I turn my brain off when I leave work (just use the stem to drive, eat, drink, breathe, talk to my wife) and I won't turn it back on until I drink a cup of mud in the AM. Maybe something will hit me. I've seen a ton of celluloid.