You sound very authoritative on the subject of pain, jingl.
I believe capsaicin can be rubbed in for pain, and eating chilli peppers can also reduce pain. Capsaicin is the active ingredient in chilli peppers.
If I have a headache, I just rub neat lavender oil into my temple and it goes away. I only rub it on for a short time, so it's not the action of rubbing that works.
Both Jane and Anya mention rosemary in their handcreams. Nothing wrong with eating rosemary. I believe that basil also helps with pain relief.
Lots of vegetables contain salicylin, which is aspirin.
(There are six different ways of spelling salicylin, none of which are accepted by spellcheck.)