Codes of Conduct can never replace good intentions, mutual respect and human decency, but in the right hands, they can be an excellent tool for bullying and abuse.
Last but not least, there have been political activists that enter a group and introduce a CoC, which they then use to circumvent the group's established democratic processes for harnessing it for their political agenda, to exclude group members with opinions they don't like etc.