Offhand, I can think of maybe a handful of instances where trouble was made by applying the CoC to someone's behavior, either rightly or wrongly. To me, it's seemed that the "trouble" that comes is when a project decides to adopt a CoC, and several members protest agains the idea of having one.