THE FLY with Jeff Goldblum. I felt queasy for a week after.
The single most terrifying SCENE in a movie, for me, would be the 'Swinging In A Tube' sequence in the EM film THE ISLAND. On the big screen I felt that I was swinging with them and nearly had to leave the theater.