Comment by Someone

> You cannot even select your own notification sound for Messages on MacOS anymore

I don’t see a UI for it, but when I drop a sound in ~/Library/Sounds (tested with .aif an .m4r; .aiff likely will work, too, looking at ~/System/Library/Sounds) it shows up in the “Sound Effects/Alert sound” pop-up for me.