I'm sympathetic to "it's corporate's fault", but instead of fixing that problem I see a lot of folks lobbying for shiny new toys, meetings to stroke egos, and basically spending their political capital on being prima donnas instead of making their lives easier from an operations standpoint--and for the rest of the docs such as yourself this obviously is a problem. :(
The roadblocks bit is what it is--if doctors were better at prescribing medications and hadn't cowed their colleagues and nurses into a culture of "oh, well, I shouldn't say anything" then automated systems wouldn't be so compelling from a safety standpoint. As it is, they are undermined continually (as explained in this article) by the humans who have to work with them and who--as you've exemplified--don't trust them.
Let's face it: in the next 30 years, most physicians who are basically knowledge workers are going to be doing work very differently than they are today, most of it with heavy computerized assistance. You can choose which side of history you want to be on.
The most common problem is when the people setting alert policies are divorced from the people receiving them. The managers have no direct incentive to keep the alerts sane or moderated. On an individual basis, every alert that exists shifts potential blame from the manager to the employee. ("It's all the employee's fault for not following the alerts.")
In this way, over-alerting is often "automated micromanagement", but without even the feedback-loop and mutual-accountability of actual micromanagement. Until the people acting on alerts have some feedback into the alert-configuring process, the problem will continue.
Another dysfunction is when people ask for alerts purely for an independent paper trail, either because they're paranoid about assigning blame, or because they want to use their e-mail client as a half-assed searchable database.
P.S.: We've already had managers asking us if we could have e-mail alerts that users must confirm receipt of by visiting the website... and for the site to continuously e-mail followups until they do. Meanwhile, the IT staff have their own horror-stories of ancient inboxes grown too large to reliably read data from.