@boomerang,
I feel the same way about Dancing in the Rain. I did like the movie as well - found it powerful in a sense. But it freaked me out enough I do not think I could see that movie again.
Another movie for a different reason I couldn't see again (at least part of it) was Alive. The beginning where people were being sucked out of the plane while still in their seats is just too frightening for me to watch again.
A movie I haven't been able to bring myself to see is the Passion of the Christ. I cry just thinking about parts of it and descriptions of it. I don't know if I could sit through it.