The only effect of a Code of Conduct I have ever personally witnessed was that people were being bullied for greeting others. The greeting they used was "hey guys", and instead of recognizing that language is fluid and different to different people they tried to impose their linguistic views on others. The people who encouraged this behavior were people on the Code of Conduct committee and at the top of the project's…
CoC's are poison, and if your project has a "Code of Conduct committee" it is dead to me.
I fully admit this hasn't been possible for everything, but I'm making great progress