Bizarrely, there was a drama about a probation officer a few years ago on BBC1, Jack of Hearts, starring Keith Allen of all people, which might be the nearest equivalent to a social work drama in recent times. However, I don't think the Beeb commissioned a second series (correct me if I'm wrong) so that may tell its own tale.
On the grit versus glamour question, each seems to work in other public service areas. I guess Holby City and Casualty are on the gritty side, and Teachers and No Angels were more glamorous (well, sort of).