I have fond memories of Demerol. I’ve had it twice: once for malaria and once for a stuck kidney stone the size of a nickel.That is exactly what I used to go through as well. And also for me the migraine came after the aura cleared up. It got to the point where I would go to the hospital where they'd give me a buttshot of Demerol. Damn I loved that stuff.
It began with the doctor asking me if I could touch my chin to my chest. NOPE. The top of my head felt like it would literally blow off. A few minutes after getting the shot I'd be wandering around just enjoying the colours, the scenery and trying to be helpful to anyone. The staff would usually guide me back to a safe haven.
Now I still do get the auras but the resulting headache is very mild and almost negligible. But I have to wait for my vision to clear up before driving, golfing etc.
Edit: I didn’t have it “for” either of them, but because of them, that’s what I was given. It sure is memorable, that shot in the rear. After that, pure bliss.