I remember watching the first episode of Cracker, starring Robbie Coltrane, on British telly and being riveted. (If I recall correctly it was written by Jimmy McGovern?) The main character is a police profiler and a successful one. Coltrane's acting chops suffused the character with charisma, so that it comes as a bit of shock to discover he is a disaster at home, with a massive gambling addiction. He is married, but he is not above getting involved with a co-worker, either.