With film, you have the “important people” listed first: director, writers, producers, editor, composer, etc., and each will have a “card” of their own. THEN, they’ll have the semi-boring credits scroll: https://www.youtube.com/watch?v=c3rlxrqmw3Y
Marvel and Pixar credits almost always have an elaborate sequence for the main creatives and cast, and Pixar sometimes the the characters playing around alongside the scroll or some other fun element like the dimensionality of the type in the scroll: https://www.youtube.com/watch?v=nAqGTR8BUBI
But even TV shows get a little playful sometimes: I watched Daria last night, and the credits were shown alongside images of the characters in weird (for the usually grounded show) costumes. It can be more than illustrations and animation, of course; with a live-action show, I could work with a photographer (or existing cast photos) to do something like that. (I’m also an experienced photo retoucher; I probably could have mentioned that.)
The Gravity Falls finale had a lengthy, “snazzy” sequence: https://www.youtube.com/watch?v=4nDcXgyTAPA
But for a low-budget project, “snazzy” could just mean attractive typography that isn’t just white text on black in Helvetica. You can do that, of course, but it’s also good to have something that complements the show’s logo and other promotional materials (including your website). Working with a designer can make everything look unified, communicate what’s cool or fun (or not fun?) about your project visually, and your show looks more professional in the process.