The found-footage film took a suspiciously satanic number on a spooky weekend at the US box office that saw Ghostbusters: Frozen Empire top the charts