I think it depends on how he story is told really. I think the goofiest monster could be terrifying if it's done right. But for me I think psychological thrillers are far more terrifying than that off monsters. Because monsters you can fight, there's a chance that you can win but when it comes to the psyche and sick mind there's not much more you can do about it, it's just pure dread.