Great topic Kat! Looks like a lot of the usual suspects have been named (Madmen, Dexter, Catch Me if You Can)but of course there's a million more. I didn't realize there's an Emmy award for best title sequence which the Oscar's have chosen to ignore.
Here is a graduation project by Dutch Jurjen Versteeg that gives a clever and brief history of leaders in the field.

A History Of The Title Sequence from jurjen versteeg on Vimeo.