One of Robert De Niro's biggest flops had real potential to be an intriguing horror film.