Both can be true at the same time. Caffeine can help with migraines but the main reason it‘s in the meds is to speed up the effect of other substances. At the same time regular consumption of caffeine (coffee, energy drinks etc.) can lead to withdrawal symptoms and give you bad headaches more often. But we‘re all built a little different and some people have much milder caffeine withdrawals than others.