my favourite visual is extremely subtle...goodfellas when deniro and liotta are in the cafe at the window table...the camera is pulling away from them while zooming in at the same time which keeps them at the same point in the screen but makes the street outside look like its getting closer and closer...
another is a very short scene in the matrix when morpheus says "load the jump programme and you see neo from above as the building zooms quickly up to meet his feet
When Luke Skywalker confronts Darth Vader for the first time in Empire Strikes Back. The silhouette of Vader and Luke, along with the glow of the sabers, awesome.
The burning oil fields in Jarhead.
Terminator 2 - the T-1000 walking through the bars in the prison.
In Jurassic Park, when the T-Rex escapes and wrecks the car, and you see Grant and Lex, and a huge foot stomp down in front of them. Awesome.
Batman Begins - the bit where he is perched on top of a tower at night as the camera swoops around him.