So when I get a notification of a new email using the stock, Communication, E-mail app, is there a way to play a custom sound?

Control panel, Sounds, Ringtones doesn't affect this feature, only with incoming calls.