I gave up alcohol almost entirely many years ago, primarily for health reasons. While the OP may be overselling it, at times it really does seem like a superpower.
If you're used to drinking in social situations, you may not realize how much mental capacity you (and the other drinkers) are leaving on the table. When you start being the soberest person in the room, you see everything with a lot more clarity than your inebriated peers. You could use this to your advantage in an adversarial setting, or just as a way to impress and charm people otherwise.
I did find that talking about not drinking made things more awkward in some situations. In that case, it's easier to "go with the flow." Indeed, I often will accept a drink and sip slowly, then dump the stuff when I go to the restroom, to avoid any awkward conversations. My favorite technique, back before the pandemic, was to order a seltzer water with lime at a bar. Most people never ask what you're drinking, and assume it's a boring vodka or gin and tonic.