Happy to share that I've managed to add this functionality to my OSTicket installation.
Whenever a new email is downloaded in OSTicket, it plays an audio file which says "You've Got Mail" 🙂
Happy to share the code.
PS: Its a functional but crude solution. I'm sure it can be better integrated.