jI guess for now a separate mail account with push set and all others to manual is best option for you.

I am pretty sure that it should be possible with some coding (e.g. python):
dbus listening for new mails and filtering text, then with aplay or something else playing sound.
I am also sure similar have been done for N900 already but I cannot remember for SFOS...