OWAtray can be used as an extremely effective way of sending Exchange email notifications to your iPhone in a highly visible manner.

This can be achieved very easily by utilizing the built in Growl integration and routing notification through Prowl or Howl (both of which are commercial apps on the iStore).
Detailed instructions on how to achieve this can be found here.

Thanks to Doug Johnston for helping me with this feature.