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.
I have also seen that CoCs were sometimes exacerbating conflicts due to communicative styles of autistic and allistic people, by lack of social skills, or by relationship breakups; i.e. situations that would have required competent psychological intervention instead of sanctions.