I remember when the show first aired, I assumed Franz' character was a more obnoxious version of his Norman Buntz character on Hill Street Blues. Turns out I was wrong.

In the end, he was a classic tragic hero -- noble and highly competent, but with his fatal flaws. And with his flaws -- the drinking, the prejudice, et al -- he tried to move beyond them. Even as he mellowed, he could still scare the bejeezus out of anyone.

This is one of my favorite Sipowicz bits:

https://www.youtube.com/watch?v=LW6Ljep0AC0