F’rinstance? Keep in mind that I live in Russia part-time and don’t always have access to the shows you might watch.
Believe it or not, Dude, but I knew what those were going to be before I even clicked on them! Just add this one!
Ah, okay, I notice the links now!
A couple of bad-ass themes, to be sure, but I’ve never seen either show… 
In terms of cheesy, however, nothing is as wonderful as Disney’s 1950s ZORRO.
How about the theme from Disney’s 1950s SWAMP FOX, starring Leslie Nielsen as Col. Francis Marion? 
I find the Big Bang Theory theme pretty catchy. Done (like Malcolm in the Middle) by They Might Be Giants.
What, no Miami Vice?
No Gilligan’s Island?
No The Prisoner?
See above, please. Two out of three… 
The most awesome Disney series ever:
I just had to post these. Possibly Disney’s second greatest series ever:
Falling (The Twin Peaks Theme) is easily one of the most haunting songs used as a TV theme.
Speaking of haunting, how about Dark Shadows?
Cheers
The Jeffersons
The Mary Tyler Moore Show
Community
Laverne and Shirley
Happy Days
The Greatest American Hero (yes, really)
I love that y’all are mentioning oldies.
Mike Hammer- definitely (thanks for naming it… never knew the name)
I definitely remember Swamp Fox!
Peter Gunn
Mr. Lucky
How about Robin Hood (the one with Richard Greene)?
More recently: Monk
ETA: Just listened to “Harlem Nocturne.” That was NOT the Mike Hammer theme. I shall research further.
Okay, further correction… I’m talking about “Mike Hammer” from the '60’s with Darren McGaven. Harlem Nocturne seems to be the theme for a later one with (?) Stacy Keach. Typing fast so as not to miss the edit time limit. I believe the '60’s show may have been called “Mickey Spillane’s Mike Hammer.” Back with more soon.
I hope you’re remembering the one from radio. If so, it was Streetcar Named Desire - Main Theme
Are you talking about the series that starred Stacey Keach? I’m pretty sure that’s the name of the tune.
I just checked. It is. But the other theme is great, too.
Aha, alles ist jetzt klar! 
No, Harlem Nocturne (by the same guy who composed the Andy Griffith Show theme – Earle Hagen) was used for the Keach Hammer.
I seem to recall another Hammer between radio and Keach, though. The radio Hammer was played by Ted de Corsia. (see Ted de Corsia - Wikipedia)
The McGavin one was the one I had trouble remembering!
Okay. Here it is.
Here’s the tune! “Riff Blues”
To me this melody and especially this arrangement captures a mood of urban, burned-out loneliness… a man wandering the streets late in the day, not having anywhere in particular to go, lengthening shadows, lighting cigarette ofter cigarette. I’ve loved this tune since I was a little girl and way too young to have experienced any of those feelings.