I'd have to say all three of the LOTR movies. Especially the opening scene in Fellowship of the Ring, the nighttime battle scene in The Two Towers, and the whole 2nd half of The Return of the King.
I also thought The Day After Tommorow had some great effects, specifically the flood scenes in Manhattan.