1. In Dune, when Maud'Dib kills Feyd-Rautha at the end.
Paul's all worked up, he looks down at Feyds' body and screams at it, which causes the body to expand and burst, and the ground to heave up and crack the marble floor.
Then Alia says, "And how can this be? For he is the Kwisatz Haderack!".
Always sends a chill up my spine.
2. Another of my favorite movie scenes is in "The Bone Collector", with Denzel Washington and Angelina Jolie.
It's when Lincoln Rhyme is laying in bed, apparently asleep, and Amelia Donaghy(in the book, Amelia Sachs) walks over to the bed, and starts slowly rubbing his non-paralyzed finger.
Lincoln opens his eyes and teases her, saying what she's doing might be illegal, or something like that.
The scene is very sensuous, imo.