The people that cancel good people are shitbags.
Relativity remains a factor. One mob's shitbag is another mob's hero. One mob's wish for freedom of thought is another mob's moral depravity.
Cancelling is just an added nuance on gossip and dogpiling, and those have been around since we've been knocking rocks together. It happens whenever a person publicly acknowledges an opinion that angers a tribe enough to single someone out. It doesn't matter whether that person is a long-time resident or a passing visitor. The more it goes against their social values, the more popular it becomes in the gossip, and the more people share it with each other as the story takes on a life of its own. Details get changed. Maybe it started with a lie or misconception to begin with and grew from there. None of that matters when people start shunning you in public or knocking on your door with torches in hand.
The only added nuance of cancelling over traditional gossip is the pervasiveness of the internet, and the distance at which people can socially band together to shun you. Most importantly, gossip has never required someone to be a good or bad person. It just needs someone to be the target of a rumor (truthful or otherwise) that pisses a lot of people off.
A hypersexualized Paladin whose test of faith is to invite admiration from all who observe him or her, but they’re not actually allowed to partake. Imagine an extremely vain god or goddess who not only wants all of the sexiest people alive as their followers, but wants them to proactively blueball the rest of the world with their piety.
Or just take the easy route: a good old fashioned fertility deity who approves of their followers sewing dem oats.