I have a few generic faves. Tarantino credits are always a blast because you can, more often than not, expect a killer song or two. Casino Royale's credits stand out because it's so damn bad ass. Amelie's is a good one because it's kinda cute/freaky and I love the music. Spiderman 2's credits are just fun and awesome. And then there's The Good, The Bad, and The Ugly, which is unrivaled.
Pulp Fiction
[youtube=425,350]CKGnUd6D6Pg[/youtube]
Reservoir Dogs
[youtube=425,350]zHGO8xAi368[/youtube]
Amelie
[youtube=425,350]BksH9YMgHlM[/youtube]
The Good, The Bad, and The Ugly
[youtube=425,350]fGIelcG0r3s[/youtube]
I'd love to post Kill Bill's intro's but can't find em.