Sopranos isn't for everyone. I love it but they're all awful really.
Out of curiosity, did you binge it?
One thing I have noticed is that if you watched it when it first aired (not binging), you tend to have a slightly different view. But if you binge it ... the awfulness is quite apparent.
Chase meant for the characters to be awful. Tony is a killer. He does so without compunction. And the Janice (anger management) and Bobby Bacala scenes? There's a reason he is the boss.
But you tended to overlook it because you want to sympathize with the protagonist, and if you aren't binging, you don't fully internalize the full horror... which was the point. As you note- these are regular people, like us, except ... they are awful.