I'm another male, and a retired engineer, not a doctor. So, first I'll offer sympathy. And, some observations.
Pain killers are interesting. I'm familiar with them because of migraine. Both mine and other's. Migraine stops the stomach so few oral painkillers are effective. I don't get many migraines, fortunately. Others in the family have found that taking a lot of painkiller results in a kind of addiction. You get rebound headaches when you stop taking pills for your headache. I imagine taking frequent painkillers for other conditions would result in a similar situation. Getting off the painkiller is an arduous process and we were warned that once off, you have to deal with the pain without painkillers. Taking painkillers again, apparently, puts you back into the old cycle.
Some engineers are good diagnosticians, others not so much. I imagine it is the same with doctors. The body is complex and there are a lot of external factors, food, drink and environment to mention three general classes. The cause of migraines is complicated to determine because it is a mix of physiologic and environmental factors. Many who are prone to migraine have blood vessels that don't dilate properly after constriction. In the general population, drinking coffee, for instance, causes constriction, but after the coffee has been processed, the vessels dilate again. Not so with migraine sufferers. So, you consume something that causes constriction. Later you consume something else that causes constriction, and later still, something else. Eventually your brain figures out it is not getting enough blood, and you get the aura. Your brain then dumps the chemical that dilates your vessels, way too much of it, and your vessels dilate too much, which causes the pain. Often, this means that coffee, tomatoes, wine, and many other things can be traced to one migraine, but aren't obvious causes in other migraines. Some people report that changes in atmospheric pressure can trigger migraine. A few years ago we discovered the steam from boiling a mixture of Chinese herbs can trigger my migraine. We still haven't figured out exactly which herbs.
Anyway, a long way of saying there are many factors affecting you and your condition. Until you have tracked down the relevant ones, you will suffer. Some doctors may be better at helping than others, modern medicine has some amazing diagnostic programs which can help rule out some factors. Your own careful observation of everything, over several months, might be the most helpful.
As someone already said, The Pill comes in many formulations and has changed quite a bit since it was introduced. One formulation may be helpful and another harmful. I don't have any suggestions about determining which might help or harm.