Swear words are most effective when they're used in moderation. That's not to do with being liberal or conservative, it's a fact. I have no problem with people swearing, since all cuss words are, essentially, just words. Why should the 'S-word' be any stronger than 'poo' or 'faeces?' It's only society that dictates that some words describing a particular concept are taboo, while others are not.
I don't like it when people pepper every single sentence with more swear words than hairs on their head, not because it offends me, but because they detract from what the person's actually trying to say. Sure, say f*** once in a sentence to show that you're angry, but going overboard on the swear words is ridiculous. But then again, it's not something I'd lose sleep over.
As for swearing in front of children, well, the jury's out on that one. It would be better to tell your child that certain people, such as Mrs Prim, don't like it when you use that word beginning with f in front of her. That way, they'd realise from a young age that some words are only socially acceptable in some contexts. I'd imagine it would be embarrassing if your child shouted out 'f***' in the middle of a christening, for example. 
_________________
"Never try to teach a pig to sing. It wastes your time and annoys the pig."