I love a movie that will grab me from the very titles. If a filmmaker has taken the time and expended the artistry to come up with a memorable title sequence, I'm all in.
Here are some of my favorites:
One Hundred and One Dalmatians. I think this was the opening of my eyes to what a title sequence could be. The marriage of imagery and content (colorists' names are brought on with a wash of color, etc.) was first brought home to me here, and I've been paying attention ever since.
Pink Panther series' titles were also clever and funny.
One of my dad's favorite films of all time was the mega-comedy It's a Mad Mad Mad Mad World. The credits are terrific. Thank you, Saul Bass.
Beetlejuice has the advantage of a great Danny Elfman score playing underneath. The spider gag at the conclusion surprised and delighted me when I first saw it.
Speaking of great themes to accompany a movie's opening, I've always loved the Mancini score to Charade. Again, take a bow, Mr. Saul Bass.
A clip does not seem to exist on YouTube, but The Adventures of Tintin have a sequence something like that for One Hundred and One Dalmatians. I like the John Williams score, too.
Here's a recent favorite, The Adventures of Tintin.
And last, for pure laughs, here's The Naked Gun 33 1/3, The Final Insult. Artful silliness.
And as far as end credits go, The Incredibles takes the cake.