It's a group thing. The social workers got together and decided what they wanted for ethics and they police them; each individual does pick and choose which ones they want to follow and which they bend or break, just as you and I have our "I would never. . ." and then find ourselves doing whatever it is because the map is not the territory and interpretation and perception can change when you actually experience a situation instead of just read about it.

However, you and I do not let others police us and we may not give ourselves restrictions, probation, or sanction when we violate our personal code, or, perhaps we do which is why so many of us see counselors/therapists in the first place, because we can be too hard on ourselves or listen too closely to others.

You say your first social worker did not harm or harass you, just that she violated the social workers organization's ethics (or maybe you only know the counselors ethics?) but you are not a social worker. I think you take the "letter of the law" a bit too strongly. The ethic codes are not that exact in their interpretation; we're all humans here.