I'm going to be that person and suggest a show that isn't a book, but hear me out. The Wire is basically the gold standard for this. David Simon's background as a crime reporter means every detail feels lived-in, from the grinding bureaucracy of the detail's funding to the mind-numbing surveillance logs. The police work is slow, often fruitless, and deeply political. It's not about genius detectives having eureka moments; it's about systems failing people. For novels, I'd point you toward Joseph Wambaugh, especially 'The Choirboys'. He was an LAPD officer, and his stuff captures the gallows humor, the trauma, and the sheer absurdity of the job in a way fiction writers who've never worn the badge just can't.
Another layer to consider is the 'procedural' part. A lot of modern thrillers skip the paperwork to get to the chase. For the real grind, try the '87th Precinct' novels by Ed McBain. They're older, but they invented a lot of the tropes because they were so meticulously grounded in the daily routine of a police squad. The realism isn't just in the forensic details; it's in the coffee-stained reports and the personality clashes in the squad car.