My favourite detective game is Still Life. If you haven't played it, you're in for a good time. And some difficult puzzles.
If you check the recommendations thread, a sticky here in the adventure section, you'll find plenty of info there.
EDIT: Sorry for repeating what Tim just said.
We were writing at the same time.
