I would expect that physical pain will only motivate immediately avoidant behaviors and will be as useless as any other kind of pain for helping sustained motivation needed to pursue long-term goals, which is usually where the problem lies. Because the lizard brain doesn't do long-term projects.
Physical pain is also kind of difficult to harness for any practical application to oneself, I suppose...
useless ... to pursue long-term goals
I agree unless you are having difficulty with that first step which starts a journey of a thousand miles.
Modafinil is probably the most popular cognitive enhancer. LessWrong seems pretty interested in it. The incredible Gwern wrote an excellent and extensive article about it.
Of all the stimulants I tried, modafinil is my favorite one. There are more powerful substances like e.g. amphetamine or methylphenidate, but modafinil has much less negative effects on physical as well as mental health and is far less addictive. All things considered, the cost-benefit-ratio of modafinil is unparalleled.
For those reasons I decided to publish my bachelor thesis on the cognitive effects of modafinil in healthy, non-sleep deprived individuals on LessWrong. Forgive me its shortcomings.
Here are some relevant quotes:
Introduction:
Overview of effects in healthy individuals:
Adverse effects:
Abuse potential:
Conclusion:
You can download the whole thing below. (Just skip the sections on substance-dependent individuals and patients with dementia. My professor wanted them.)
Effects of modafinil on cognitive performance in healthy individuals, substance-dependent individuals and patients with dementia