I remember that episode. It was CSI:Miami.
But seriously, if *that's* the thing that put you off then I don't even know how you made it that far. Mostly because CSI Miami departed the land of the firmly ground in reality and wound up tethered somewhere in high orbit far before that episode.
That said it was certainly my favourite of the CSI series. Possibly because of that. None of the shows were remotely realistic in a wide variety of ways (oh god the pixels please no don't zoom any more!!!11), but since CSI Miami more or less gave up any pretense that it was meant to be and instead was 45 minutes of Horatio being awesome, saving women and children and shooting very heavily armed but remarkably inaccurare bad guys it was actually far more entertaining.
You could say that this new spinoff
Is CSI: DOA