HarryOru

As a Spotify direct replacement you can go with YouTube Music.

Favorites:

• Veronica Mars (just the perfect match for the show's vibe and a damn catchy song)
• Fringe (loved how they used it later in the series to match the universe/time period the episode was set in)
• True Blood (a classic, wish the show matched its atmosphere beyond season 1)
• Jessica Jones (so underrated)
• Severance (extremely creative and memorable)
• Stranger things (hate the show, but the intro is undeniably brilliant in its simplicity)

Honorable mentions:

• Yellowjackets (fun!)
• Dexter (love the concept, hate the song)
• The 100 (after a basic title card in season 1 they actually added an intro for the rest of the show, with the content changing to match the theme and setting of each season)

I can't really think if any "worst" ones although in general I don't like when shows only do static or just very low-effort title cards. Some examples that come to mind are Breaking Bad and The Boys.

I think for me it's not so much the amount of episodes but how they are released. Most of my favorite shows have varying amount of episodes per season but they all were released weekly over several years or at least months. And I've come to the realization that the reason why I can't grow attached to modern shows the same way I could with 90s-00s and early 10s television is that binging 6-10 episodes over a couple of days once a year just isn't the same kind of experience and emotional investment as following a group of characters and a plot week by week over several seasons, literally growing up with them and the story.

I'm not saying today's model is all inherently bad but I personally often miss that kind of old-school television where reaching over a 100 episodes was almost the norm for even semi-popular shows. I wish they could coexist.