Honestly, it’s not even multiple exclamation point that get me.
It’s the double exclamation specifically.
Ending a sentence with one exclamation point: very good, nice emphasis.
Ending a sentence with three or more exclamation points: okay, we’re going dramatic, right on.
Ending a sentence with exactly two exclamation points: I have no idea what’s going on.
It’s like sentences that conclude with a double bang occupy some sort of semiotic liminal space between the emphatic and the histrionic, and I just don’t know how to respond.
I’ve been using double exclamation marks recently for like a hybrid sincerity/enthusiasm feel, when one exclamation mark doesn’t feel sincere enough but three would be overdoing it. Like “thanks!” is just basic politeness at this point, so “thanks!!” is a genuine note of enthusiasm but not quite as excited as “thanks!!!”.
But I’m pretty sure I’m still in flux with multiple exclamation points, so maybe I’ll upgrade to three for this purpose in a few more months.