I did and do still like the Pink Panther movie openers.
The opening was also the only thing passable for good with the Thunderbird live action movie.
Oh also can't forget se7en, and Final Destination.
Moving off movies for one TV Mention. Waking the Dead (BBC UK) has a nice se7en inspired one.
YouTube - Waking the Dead - Title Sequence