Curious if there's research - I'm sure there's tons, I just don't know that literature - but personally, in my experience as a professional aviator and as a spacecraft operator, the fatiguing alarms are the ones that are triggered in normal situations. If you start blinking red and squawking at me when I'm doing something nominal, you are training me to ignore you.