I'm currently watching the latest series on ITV1 in the UK. This show works for me because of its treatment of the 'everyman' character of Dangerous Davies.
This is a man who you'll usually find in every workplace: the chap who just doesn't fit in. But that doesn't mean that he's not good at his job, only that his colleagues assume that he can't be very good at it because he's not 'one of the lads' at work.
He doesn't have the 'nasty' qualities (nor the ambition) that would help him to rise above the rank of detective constable in the CID. And it's this niceness that seems to be the reason why his marriage has failed.
Peter Davison does a great job of showing that 'nice guys finish last' most of the time, but not all of the time. Meanwhile the script has an appropriate balance of humour and drama. Sean Hughes, as Mod, is also a good character, not only laying on the comedy, but also as a device that allows us to see a bit more of Dangerous's character through their conversations.
I plan to read the books (although they were published a long while back), and will have a look at the Bernard Cribbins film version from the early 80s. But please, please keep this version going for at least another series ITV!!