Pulp Fiction has a pretty good one, Reservoir Dogs too come to think of it. No action, really, but a cool discussion and then straight into an awesome song and opening credits.
James Bond movies usually have decent opening sequences.
I'm drawing a bit of a blank here, actually. Sorry. Hope...