A cracking intro in the 1960's was the Beverly Hillbillies.
As for theme tunes, my favourite has always been Lives and Loves of a She Devil starring Denis Waterman. The theme tune was called Warm Love Gone Cold sang by Christine Collister, which is a very beautiful song.