Is Cancel Culture harmful, helpful or somewhere in the middle?

I don't think there ever was a cancel 'culture' at all. It's just what people do ordinarily anyway, in day to day life. "I like you, you can stay. I don't like you, you can leave." That's it.