I think Grandstand used to have a good theme tune, I liked it as a kid, can't remember it now though!
Also the snooker theme tune when it was nice and simple and played on an electric guitar. They've ponced it up now though.
And the theme tune from QI's very jolly.