If I’m being totally honest, in all my 61+ years I have never heard of this affliction/syndrome.
There are, of course, certain “noises” that can annoy me at times, but I cannot think of any that drive me crazy.
Kids crying, etc. (we raised 3, and now have 2 granddaughters), someone stirring their coffee, someone clicking a pen, etc., etc., etc. have never really bothered me. Also, having worked in an office setting for more than 4 decades, I have always been mindful of my own “noise”.
Our middle child (son, age 31) is on the autism spectrum, and deals with a good bit of OCD.
He makes plenty of repetitive noises often…with his feet on the floor, objects, etc. Doesn’t even realize he’s doing it the vast majority of the time, or that others may be annoyed by it. After a little while of it, a quick, gentle reminder usually stops it, with him maybe getting in one last dig…!!!!!

None of it annoys me to the point of driving me crazy, and I can’t think any family members where this is a problem.
And, let me stress that I completely believe this is real, I just have never heard of it before. After I read through most of the thread I understood better, and am just very thankful I do not, or anybody I know, suffer(s) from this.
Also, your first paragraph makes me ponder that maybe it’s not so much noise, in and of itself, but the fact that the person suffering from this is not in control of the noise being made, as in they’re not making the noise, thus anticipating it…..if that makes any sense…?
Anyway, interesting subject, for sure.