I do like the idea of doing something different with Trek, other than just another deep space mission, but a CSI-style show in the 24th century wouldn't really have much build up. Technology and alien abilities takes away from building up much suspense.
ACT 1: Scene 1
Commander Murphy, Lieutenants T'Pell and Oxaal arrive on the site of a brutal murder, a human woman lies in a pool of her own blood. T'Pell opens her tricorder and takes a scan.
T'PELL: Sir, I am detecting Bolian DNA fragments. Their level of degredation indicates that the individual was present at the time of the murder.
MURPHY: Compare it to the Federation DNA database.
T'PELL: Uploading now. [Seconds later] I have his identity. He has a criminal record for assault and attempted murder on Bolarus.
MURPHY: Murphy to transporter room. Lock onto his signal and beam him to the brig. [Looks at Oxaal] Let's put your Betazoid abilities to the test and then we can put this case to bed.
END
Ok, very over-simplified, but in a time when technology can do whatever the writers need it to do in order to tell a story, it doesn't leave much wiggle room for proper cop-show elements.