Anthony Hopkins' The Rite was also quite underrated. Not visually scary but the idea of demonic forces was psychologically disturbing. Apparently that movie also based on real events.
The Exorcism of Emily Rose was one of the scariest movie I've watched