I think most people who use it are just scared from the uneducated downvotes/ backlash and I think it just ruins the sarcasm.
I started to avoid using it on other social media as it seems kind of dumb.
My opinion for it on Lemmy is mostly the same but it might work better here if Lemmy had a sarcasm tag instead(the same way NSFW tag work)of /s to signal the sarcasm instead.
I personally like using 😤 for “confidentally stupid” sarcasm and 😬 for “yikes” sarcasm.
There’s also the classic eyeroll 🙄 but that one’s usually a bit too aggressive for me.
Oh and 🫠 and 🙃 can work well too!