My own personal take is different. The sensation of pain as erotic is entirely "Dragon-dependent" for me. If it is coming from Him and is turning Him on, then it becomes insanely erotic for me.

If He were doing something to me that did nothing for Him, it would fall flat with me also.