Snatch:

Scene with Mickey at his mums wake. Cool camera effects that reflect Mickey's drunkness.

And the fight scene where Mickey is knocked to the floor, cool cam effect again, as mickey appears to have been dropped down into deep water, and is looking up at himself having the shit kicked out of him. Then the scene goes on to show Mickeys slo-mo one punch knockout - complete with saliva and sweat spray, as well as ripples in the other guys face.

Anyone who hasn't seen Snatch I would recommend they go buy it....NOW! Take a look.

Lock Stock and Two Smoking Barrels

The poker scene near the beginning has some cool cam effects. And yes, Lock Stock and Snatch, I am a Guy Ritchie fan.