one of the most pleasurable things I've ever felt in my life was not sex or any vice but the time I stepped on a nail and it went deep in my foot, the area was tender, but it felt good to press into it, outweighing the pain, and I've never been able to recreate it since.
I assume it was endorphins