
Which one? There have been four or five made, and I think a few more are in production.
I've played CSI: Dark Motives, and thought it was pretty good. The only problems with it are the controls take a bit getting used to, and I had no idea what half the tools did when I started playing. Aside from that, it plays like 5 episodes. All of which were fairly interesting and had the expected twists and turns. Dark Motives was a pretty good game considering I'm not a huge fan of CSI, I just like puzzle and investigative games.
Another game you might like and I thought was better: Law and Order: Justice Is Served. Fair warning, I'm a Law and Order junkie and that probably influenced my opinion.