When I read the title of this thread the first TV show that popped into my head that has the most memorable opening credits at least for me is The Big Bang Theory. I feel it's the music they use for the theme and how catchy it is that makes it the most memorable for me.