In my mind the Dexter sequence joins the opening credit sequences for To Kill A Mockingbird, Six Feet Under, and Anatomy of a Murder as the best examples of the form.
To Kill A Mockingbird title sequence by Stephen O. Frankfurt
Six Feet Under title sequence by Digital Kitchen
Anatomy of a Murder title sequence by Saul Bass
If you want to soak up some more brilliant title sequences, spend a few hours touring the Art of the Title Sequence Web site.