There have been some great animated opening titles too. One of my recent favorites is from the British show HUSTLE. The new USA network program COVERT AFFAIRS also has slick animated titles. I wonder if they were made by the same company or at the very least the COVERT producers used HUSTLE as their template.
Here's both HUSTLE and COVERT AFFAIRS.
Note: the worst 60s teen theme is next.