I don't watch the Sopranos, but I thought I need to share my .02

Profanity can be used as something that has meaning. Saying it once or twice can be more powerful than you might think.
However, when it's been overused (Taratino comes to mind) it can lose any power meaning and become just another word.

When used at the right time and the right amount of times, you get a much better dialogue compared to hearing every other word.

However, while some people might find this stuff "real" in their movies, I'm more of the type that likes beauty pictures. I admit, I'm soft. I don't like my movies/shows to hard.(which is one of the reasons I'm not a much of a fan of Quentin Taratino)