The Night House, a supernatural psychological horror film, has impressed fans with its "tension-filled" storyline and left many reeling from its unexpected ending