I've always been fine with it, but then I'm a big fan of Miller and Bukowski. Sometimes profanity can convey a brutality (of thought or action) that other words can't.

Alternatively it can strip a concept down to it's very bones, without the over-decorative phrasing which can blur the image.

It really depends on what you want to convey, I guess.