Tbh I use it most internally as a response to some situation, but it's rarely spoken. I tend not to use it very much around people, because it sets the mood in a particular way that's pretty depressing.
I'm kinda ambivalent about the subject, because I know people don't really wanna hear it the same way I don't enjoy the company of someone who's cursing just for show, that is pretty sad behavior. On the other hand, I don't have a problem with it if I know the other person is cool with it.
There is another aspect to this. Basically, cursing is all about recalling certain images or emotions that the other person can't avoid being reminded of, that's how curses work. That's why they are uncomfortable. But a lot of common curses have lost their attachment to their original meaning and are just sort of general words of exclamation. Those I have no problem with. What I don't like is people who take some kind of perverse satisfaction in composing new curses just so they make the other person visualize what they just thought of. That is just gross.