My views on Codes of Conduct are pretty nuanced, and frankly, I learned a long time ago that the Internet cannot handle nuance. I was and still am an enthusiastic supporter of Rust's CoC, but you'll also notice that none of my personal projects have a CoC in them. So from that alone, you might at least surmise that I don't necessarily think CoCs are a universally good idea (or more precisely, "worth it") in literally every situation. Equivalently, I think they are a good idea in
some situations. But I'm not going to say much more than that.
> I very much dislike COCs and overbearing moderation teams in open source communities.
Same. And I have avoided some such communities in the past.
But, I am not necessarily against overbearing moderation. For example, r/askhistorians is one of my favorite subreddits, and I would attribute that state to their intense moderation.