Surprised no one else mentioned Inglorious Basterds yet, the whole glass of Nazi inspection/milk/under the floorboards thing.
I'd give another vote for Dark Knight which I always felt did a great job of getting you into the mood of the film instantly.
Trainspotting & Goodfellas have the classic start in the middle, then go back to the begining which are pretty good.
And Pulp Fiction + the opening credits another good Tarantino one.