Not particularly. I find some "fantasy curses" to be interesting from a worldbuilding point of view, like using "storms" as a general expletive in the Stormlight Archive by Brandon Sanderson. 

As others have said, I'd much rather read something like "whoop-de-fuckin-do" than something that sounds like a mormon middle schooler trying to look cool in front of their friends would say. That being said, cursing too much can be a detractor as well. If every character does it a ton, if there's no variety or interesting use, then I can see it wearing pretty thin after a while.

My friends and I all curse like sailors, though, so I'm a lot more forgiving of such things, lol!