Great call on Art of the Title.
I love them (opening credits) as well.
Here are a few:
Catch Me if You Can is great and a total rip off of North by Northwest
Dr. No - although the switch to 3 blind mice is kind of weird
Do the Right Thing - Watch Rosie dance to PE
The Pink Panther - The opening title sequence is probably more famous than the movies themselves.
But my favorite is Dr. Strangelove. Sex between airplanes never looked so good.