Part of the problem of all these shows like CSI is that for all their supposed realism, they're more contrived than most TV cop shows. That and everybody in the show is so butt ugly I can't stand looking at them. What's missing these days is the high concept police drama of shows like MacMillan and Wife. Now that's entertainment:

San Francisco Police commissioner Stuart MacMillan and his beard - oops - wife Sally, solve crimes in 70s polyester high fashion		Yes Mac does what all police commissioners do, personally fighting crime in the streets with his fists.
But before we get ahead of ourselves, lets have a drink.		Crime rings are easy to infiltrate because they often gravitate towards society parties where a friend or acquaintence of Mac can be suspected of murder or jewel theft.
Remember, puffy shirts are always a good choice for party goers.		Something else commissioners do is let the media interview you at the crime scene while walking on evidence
Ooops don't forget your flask on the way to the office. Drinking on the job is okay when you run the police force.		Schedule some qualtity time during your daily commish duties to chase murderers through San Fran on bikes.
Fighting criminals is tiring so you better have another drink		Take your beard/wife to the crime scene so she can be endangered by criminals (once you've got your hetro look established in the public's eye you can kill her off with a plane crash in season 5 and bring in Martha Raye)
And finish off your day with a good stiff drink

They just don't write TV like that anymore.