Saul Bass king of the title sequence. There are so many great ones but the intro of North by North West is a great study in design and excecution.
Here are two examples of his great work on films at opposite ends of the spectrum
it's a mad mad mad mad world
For further reading/viewing of his work go to: