I think it depends on one’s knowledge of language, ability to manipulate and play with language, understanding of the society, history, and your present company. If you open your mouth to speak and don’t have confidence in what you are about to say, that will show up, regardless of profanity or not.
As for someone finding something offensive, that’s part tradition, and personal upbringing. We have words that as a collective we agree are “bad” or that a certain population can’t say. The “N-word” is something I am not allowed to say as a white man. That wouldn’t be just offensive, it would be racist. In German, many words were removed from common use after WWII in relation to Nazi propaganda.
But as to the word “fuck”, I hand the mic over to the late George Carlin: