I've been thinking about this discussion and while I definitely don't like screamers/yellers as a general rule, I thought back to some of my daughter's best coaches and recognized that they definitely yelled from time to time. But, I realized that it's the content of the communication, not the volume of it that really matters. A coach can whisper sh*tty things to a player and it could be abusive. My DD had one coach who was yelling so much (in Spanish) at other players in her first practice that she almost walked off the field, she was so intimidated. However, that guy turned out to be the most caring, supportive, and long lasting coaching relationship of her youth career. He yelled, but he never yelled demeaning things. He would also make sure to yell his praise even louder than his displeasure, and always ended practice by shaking hands of every single player and thanking them for coming. He could yell and be loud, but he was never disrespectful, just intense and passionate.
I once heard an interview with Tony Dungy where he talked about how counterproductive yelling is as a teaching and motivational technique. I do think it can be useful for good coaches who care and are able to demonstrate that care, but if you have coaches who yell AND don't give a sh*t about how their players feel, that's a baaaad combo.