Good question. Usually the music is far better than the actual intro, Succession was a good example of that. 24's intro isn't much but it's unique and ages well because nobody likes sitting through TV show intros anymore.
I'd have to say that Whiskey Cavalier's intro is the best one I've seen, from what I can think of off the top of my head.