The trench run in ANH is my favourite too. I love the shot when the X-Wings enter the trench, and I'd kill to be able to see that in the cinema (yes, I'm one of the deprived few who's only seen the OT on video - I haven't even seen it in widescreen ).

Other moments I like are:

Pod race
Battle of Hoth
Battle of Endor
When the Ark is opened in Raiders
Asteroid Chase (ESB and AOTC)
Coruscant
Mine car chase

LOL, I wonder if someone has choices besides the Star Wars movies, maybe the subject of another thread.

From the originals I like the imperial walkers from ESB and the space battle in ROTJ. From the prequels, the Pod race and Coruscant night chase are my top picks.

But as far as the whole body of work some really standout moments are:

The water pseudopod from The Abyss.
McFly family at the table in Back to the future 2 (an amazing split screen job)
Many of the mechas (the secretary at the beginning and the nanny intro shot) and both NY flybys from, AI.
The bomb runs from Pearl Harbor.
First Imhotep.
The dinos from JP, in particular the first bronto scene.
Draco comiong out of the waterfall
Willow's morphs
Forrest Gump with the presidents
Vermitrax from Dragonslayer, especially the final battle
ST2 Murtara nebula battle