I was always "eh" on most of them...Some added to the show (Smallville, GOT come to mind). Some have cool music, but uninteresting graphics (Walking Dead, The Affair, I'm looking at you). I prefer the Breaking Bad method - a bar of music and a title card.
So glad Riverdale doesn't have them. Although a Veronica Lodge slo-mo head turn could convince me..