While lost in a deep Wikipedia hole, I found myself reading up about the production company Klasky Csupo, which in turn inspired me to hunt out the (surprisingly hard to find) Rugrats title sequence, which I have embedded above.
I've not watched it in years but, boy, that's some brilliant animation eh? Combined with the Mark Mothersbaugh theme, I think it makes for one of the most charming intros to any tv show ever. Rugrats itself, at least the seasons before they added the little brother and had them grow older, was great.
Klasky Csupo's other 90s output was also really strong. They were often weird to the point of alienating kids, but their artwork was always bang on. They had amazing logos and music too. Check out clips of Santo Bugito and Aaahh!! Real Monsters for some other goodies.