As there is no support for the Gmail app any more you should try Enhanced Googlemail which uses the Blackberry push system (find Setup - Email setup (it's an envelope) - and this will create a folder for each account plus delivering all emails to your Messages Folder which has an on screen alert and counter for all messages combined.

In Profile (click on your speaker icon) you can create a sound alert for this as well.