one-night stands

Ah, the sordid glory of the one-night stand. It's much-dreaded and much-coveted. It's confusing. But are they any good for us?