OTC medication is not typically strong enough to fully fend off a migraine (no, excedrin migraine doesn’t count). Go see a doctor, explain your symptoms etc and get prescribed something like rizatriptan.
Seconding Rizatriptan. It's a game changer. It also seems to work better earlier, before the pounding really sets in, but in the worst case it still turns it down a lot.
In addition to triptans, there's another class of migraine medication that's relatively new, but given the cost and back and forth your doctor will have to do, they prefer to start with triptans: *gepant drugs like Nurtec and Ubrelvy.
Emphasis on the "something like": there are several different drugs in this class (triptans), and it might take a couple of tries to get one that works for you.
Personally, sumatriptan doesn't work reliably, rizatriptan makes me feel super woozy, but eletriptan works well and without noticeable side effects.
