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