Do people actually enjoy receiving discord messages or being notified? I won't deny the sound has conditioned me, but it's my fight or flight response that's being triggered.

There's a special place in hell for youtubers who use this sound in their videos.

Are you sure? I think the responce Iv been trained to feel is a bit more negative then this persons here

If you click, I sit.

Discord sounds = off

I had a friend who would take really long to respond to my texts and I would have sent like three times the content because I would pour out my unfiltered thoughts a lot. They would only reply to the one topic they wanted to talk about. At first it made me feel a little nervous that they didn't want to hear about some stuff and weren't reacting to it, but they explained they were fine with it. So, I was basically given the go ahead by someone to say just whatever I was thinking. So whenever they did reply and I heard the notification sound they had found whatever I said interesting enough for them to want to start a conversation about it with me.

Mastodon notifications almost did this. Luckily I successfully cut off my INSANE posting rate after 9k posts that took me... 4 months to get to.
I got to 6k posts in the first two months alone.