The only show that consistently does it for me is First 48. I love that show because it is the closest to the real thing that any cop show has ever been. "Cops" is BS because a lot of the time the cops are playing it up for the camera. And besides, routine patrol is something I'm fairly familiar with anyway.
I was never really a fan of the show, but I do remember one time I saw it there was a cop on there who saw a house on fire, and went up to the front door to alert the residents and get them out of there. The front door was one of those metal grids with little 2 to 3-inch square windows. So he bangs on the door, rings the doorbell, and then starts busting out these little windows and still cannot reach through to open the door, so he just keeps busting out more of them even though doing so provides no access whatsoever to the other side.
Finally some lady comes to the door and opens it up, and she's like "WTF is your problem, officer?"
He's like, "Ma'am you have to get out, your house is on fire!"
She says "No, it isn't."
Then he looks, and realizes that the fire was actually at a different house on the other side of the block. So, he busted this lady's door for absolutely no reason.
I have occasionally watched it again, but never saw anything remotely as funny as that.