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.
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.
Personally, sumatriptan doesn't work reliably, rizatriptan makes me feel super woozy, but eletriptan works well and without noticeable side effects.
We tried with diclofenac first, didn’t work at all.