They're all here. Lovelorn wife, old cop trying to stick around, gangsters with neat nicknames, forensic lab work, stool pigeons, etc. There is also an uninteresting back story about a job the wife is trying to get for her husband-cop, to "keep him safe". Think of a familiar plot device and it's here in "Scene Of The Crime".
That said, this picture holds your interest - it's a good story, when all is said and done. Good acting from start to finish and there are lots of good character actors; John McIntyre, Norman Lloyd, Gloria DeHaven, Jerome Cowan, and many others. I disagree with a reviewer above in that the picture held my interest right to the end, although I am a big fan of noir films. I did think that Van Johnson was a curious choice for the title role. I always thought there wasn't a mean bone in his body, not tough enough to play a detective in a gritty noir.
Lastly, the music director was Andre Previn, and the theme music at the beginning and end was good. He also wrote two songs that were unworthy of him, but they were played in a strip joint and fit into the setting with their trite tunes and lyrics. Despite all of the preceding, I rated it a seven, which means I think it's worth your time.