For pure shock the worst I watched was Cannibal Holocaust, there is a reason it was banned for so long.
The scariest to me is still The Exorcist.
I am a massive horror fan though and love my classic slashers like Jason, Freddy, Michael, Pinhead etc.
I may have to finally sit down and watch Event Horizon after reading this thread though