Pretty much a lot of 80s/90s cartoons weren't that great content-of-episodes-wise (I still watched the heck out of them as a kid), but had these amazingly catchy intros? Beetlejuice, Ducktales, Dexter's Lab especially come to mind https://www.youtube.com/watch?v=CB2WJG-YvP4