One thing I will say for the CSI intros is that they haven't truncated their openings to make room for more commercials.

Some other standout intros from modern TV:

MAD MEN (I can't believe I forgot to mention this one)
HOUSE
DESPERATE HOUSEWIVES (before they started truncating it)
RESCUE ME