Because I'm disagreeing with you above I just wanted to explicitly state that I agree with this. Particularly the second paragraph.
Profanity needs cultural weight not just a certain tone of voice.
In English at least. Can't speak with any authority on other linguistic cultures.
As such, making up words to use as emphasis words doesn't actually offend, which is largely what makes the bit you link to funny, as far as I can tell, and it's why "darn" and "dang" are much less offensive even to those who would censor swearing.