I'm so sorry Jay. Urgent care can help but if the migraine is already pretty "set in", it can be difficult. At least that's what my neurologist has told me. Sometimes the fluids they give help more than the actual pain meds. Regardless, I'm so sorry that you had such a negative experience.
I understand that pain though, you aren't alone. The last time I was in urgent care for a migraine, they gave me an IM injection of torodol which did nothing and hurt like a bitch. Then they gave me an IM injection of a "migraine specific" medication (I think it was sumatriptan) which hurt like a BITCH, wowza that one sucked. I thought I had to be having a reaction to it it hurt so bad. When that didn't work either, they gave me IV fluids and an anti-nausea medication. I already have pretty high anxiety and a needle phobia so I was already at my limit anxiety-wise and the kind PA overseeing my care neglected to tell me that this anti-nausea medication can worsen anxiety and cause panic attacks in people who already have anxiety. It was the most horrible experience. I wanted to die right there in that bed. They gave me benadryl to calm me down and my most wonderful boyfriend who was there with me held my hands and talked to me and calmed me down.
In the end, it ended up helping (i think). Between the fluids and benadryl and maybe the painful af muscle injections, I came back and slept and was feeling much better the next day.
You also aren't alone in your migraine suffering. The only reason I'm awake rn (it's 430am here) is because of migraine nausea and pain that I woke up from and I'm trying desperately to ignore.
I'm so sorry you're suffering. Idk if it helps, but know this won't go on forever. Eventually this migraine will end. When it does, if you don't already have a neurologist, I would recommend pursuing getting one. They can prescribe really helpful medications like RJT said. I am on sumatriptan now and it helps a ton. I also take preventative supplements (magnesium and B2) that they recommended.
My prayers are with you that you will find relief ❤