Yelling can only deliver results when it comes sporadically, not as SOP. People who yell 99% of the time to try and motivate or prove they are the boss, lose respect quickly. There are always exceptions to the rule like Bobby Knight or Woody Hayes but that was more about the legacy of the school and the program.
Any boss in my life who tried ruling by being a tyrant had the shortest and least successful career.
As people age, they respond less and less to people yelling.