In fact Messenger Plus! Live still allows you to choose sounds, you will find that if you go through the Event Notifications Wizard you can still choose if you which to have a sound for a particular contact and/or event.
So it hasn't been forgotten if you go through Plus! -> Preferences -> Customize! -> Event Notifications
Red Bull Racing Australia - Triple Eight Race Engineering - Holden
/ 
