Once upon a time, Thunderbird could set an alert sound to a specified (local) folder. Unfortunately, this function was annulled in a later update. I keenly propose to resume this function.
Thanks for submitting an idea to the Mozilla Connect community! Your idea is now open to votes (aka kudos) and comments.