The problem with explicit code of conduct is that there is always a implicit interpretation of what the code of conduct say and how it should get enforced.

If we could get an explicit code of conduct with explicit interpretation with explicit enforcement then yes, they work quite well. Sadly most communities leave interpretation and enforcement up to the dominant group with an often explicit desire to not have those parts visible.