The only time I've ever seen CoC invoked is as a kind of weapon to settle petty disagreements. Something someone disagrees with becomes "making me feel unsafe" or such nonsense. They're one of those ideas that seems harmless but in practice is only something agitators use to make the project about them (usually some woke ideology thing) instead of the project. I would never get involved in project that had a CoC.