Depends on the pain I guess. I love pain being inflicted but because I enjoy it it shoes in my face and noises etc
If it's a pain you don't enjoy and that shows physically then I can see how that would be a turn off.
If we're talking instant thumb screws type pain then no, but if we're talking slowly building the pressure on something such that your brain doesn't know if its pain or pleasure then yes - it can be very good (without harming of course)