If you think this is interesting, there's an entire site dedicated to title sequences in film and television:
And an easy way to share my personal all-time favorite title sequence, Delicatessen:
Lots of great sequences from the 80s presented there along with on my of my all-time favorite openings - Ghost in the Shell [0].
I've always felt failing to put together a compelling opening is a missed opportunity, particularly for a series. It's a hook, a primer to put the audience in mind of the best eras and episodes every time.