I've seen the example in your work. In your work it works, because you used it sparingly (only once) in a situation that justifies it and you've established the emotional baseline before. The readers know that he screamed and raged before, so this one all caps tells them how much stronger and louder his shouting is in this case. It works well as a way to stress how this shouting varies from previous moments of shouting. The problem with other writing is that the authors often establish all-caps as their baseline and it makes it look like the characters are hyperactive like the old hyporactive ferret girl or the youtuber Fred. It makes it look like his shouting all the time. And you know what they say - if you stress everything (with all caps or bold font) then you aren't stressing anything. Hyperactive people are annoying because their tone of voice suggests justified excitement even before they say what they want to say. After they say it it becomes clear that the payoff did not justify the excitement... and every other of their messages follow the same pattern. It's basically a callous and continuous abuse of human attention-directing mechanisms.
PS. Terry Patchett's death speaks in allcaps. Always. But it has been established that it is his normal, hollow voice. A voice that you can hear in the brain without it going through your ears. Allcapsing is here basically a way to differentiate it and remind the reader in what voice to read his lines (yes, Death is a HE in Pratchett's world).
I personally hate characters speaking in ALL CAPS. There are plenty of other ways of getting across that a character is speaking loudly, yelling, etc. It comes off as very amateur and highly unprofessional. The only time I like to see all caps in writing is when used for company names, abbreviations, etc. where it is grammatically correct to have them capitalized. Aside from that, however, it makes me cringe and turns me away from pieces.
Being serious, ~Hurricaneclaw is really on to something about genre. I almost never have a problem with caps lock shouting in comedy, provided it's not used excessively. I almost never like caps lock shouting in serious work, even if it's used just once or twice.