You can definitely go in and purposefully change the notification sound for each app and even each contact (literally no one does this though). I didn't know apps themselves could have custom notifications out of the box though. That seems like a really annoying feature.