Is insidious really that scary?

No spoilers please, but is it really scary? People say it might be the
scariest movie ever... Do you agree? If not, say which movie really
frightened you.