I don't view moderation as attractive in the least and I don't put a moment's effort into romanticizing it. Honestly, if I drink, I want to get loaded: I see no other purpose in drinking and never have.
It's not just that abstinence is easier or better: for me, it's the only thing that makes sense.