I've experienced very slight motivation-enhancing effects from various stimulants. But the only thing that I've found to really work so far is falling in love. Unfortunately, the side-effects are enormous and it doesn't work under arbitrary conditions, either…
A data point: compared to the median of the population, I'm high-functioning in terms of IQ, but not in terms of the ability to get things done. The few times I've tried modafinil (due to the headaches and nausea I get from it, these have not been more than a handful), it has helped a lot with the latter.
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