The AVClub has put together a list of “22 TV Opening-Credit Sequences That Fit Their Shows Perfectly“. They’ve compiled a great list spanning the last 50 years.
Watch their picks and then read this Christian Science Monitor article on the current state of TV titles. According to them, producers have become wary of rampant channel flipping, and as a result, will often forgo title sequences in an attempt to draw in an audience. I think if the titles are good enough, people will watch; all you have to do is hire the right talent.