Rabi flings her opinion into the fray:
I’m against alcohol-induced hookups, for most of the same reasons you mentioned in your post. but completely sober one night stands can be very meaningful, in their own way. I think. not every relationship is intended for longtermness, and just as it takes a special pairing to last a year or more in a committed relationship, it takes a special pairing to make a single night significant and resonant, emotionally as well as physically. and it can happen.
that said, I think most one night stands are probably pretty pointless, emotionally. people don’t treat them with the respect they deserve.
Of course, not everyone has to agree with Rabi (just me), so feel free to add your own opinion to the mix.