What separates a novel from being just good to being great? We can talk about plot points and characterizations and originality. All of those things, of course, count for a lot. However, what seems to really define the difference for me is if I remember parts of the book (or movie) for years to come. I could enjoy a book, feel drawn in, feel satisfied when I'm done, but if you ask me in a year or two and I can't remember much about it, then maybe the book wasn't great (or maybe I'm my long term memory is just getting worse--always a possibility.)
ex.) In Titanic when Rose has to let go of Jack's hand in the water. In Romeo and Juliet, when Juliet awakes to find Romeo dead.
ex.) In the movie The Ring when the little girl steps out of the tv. In Stephen King's (who is the master at this type of moment) The Shining when the wife finds the stacks of typed pages that say "All work and no play makes Jack a dull boy."
Ex.) In the Mortal Instruments series, the scene with Jace and Clary in the fairy court. In Charlaine Harris' Sookie books, (hmm, there are so many, where to start), I'll say in the fourth one Dead to the World, the shower scene with Sookie and Eric. (By the way, did anyone see True Blood last night? Talk about raising the temperature, whew. :) But I digress.)
ex.) In Knocked Up when the friend walks into the delivery room and she screams in her most demonic voice for him to get out.
Ex.) The examples are all over the place. Every book and movie has one of these, it's the climax. But the key is to make the reader really care about getting there. We have to feel personally invested in the outcome. If not, we're left cold.