I think 'The Bill Hodges' trilogy by Stephen King is a great example. Although it's not a traditional police procedural in every sense, it involves retired detective Bill Hodges dealing with a deranged criminal. King's writing style makes it a page - turner.
The 'Dalziel and Pascoe' series by Reginald Hill is worth mentioning. It has two very different detectives, the rough - around - the - edges Dalziel and the more cerebral Pascoe. The series has a long run and covers a great variety of cases.
Sure. 'The Ruth Galloway' series by Elly Griffiths is excellent. Ruth is an archaeologist who often gets involved with police investigations. The books blend archaeology with crime - solving in a really interesting way.