I’ve always thought that a bad intro song tanks a show (back when you couldn’t skip them). Conversely, a good one makes people stick around and give the show a chance, so it’s more likely to succeed.

Re: the OP question: Magnum PI (OG) SNL intro music 30ROCK Friends (ugh, I know, it was catchy…) Venture Bros. Archer Futurama …and more!