It does to me, at least. If I know someone at all, I can usually tell if the pain is being inflicted to please me or because it pleases the person inflicting it. The former can turn me completely off, even if the pain is enjoyable. The latter can turn me on in an instant, and make even the worst pain bearable.

But again, that's just my 2 cents.