There are two different discussions here.
One is about harm done physically or emotionally in real life. And the other is about artistic merit and intention.
The first, I'm much more of "doesn't matter what you meant, the result is terrible," and actions are far more important than words.
The second is a lot trickier. Art can wound emotionally. Say Wonder Woman #7, as a mild example. I'm not wounded, I'm unhappy and a little sad about it but I think the intentions of the creator went to "well, this is a good story for me," and was sort of blind to the implications of their tale. But art doesn't exist in a vacuum, so there are implications.
People should treat each other as if the actions matter, not the words.
Art is another matter.