I've suffered from migraines since I was a kid, though thankfully not as frequently as some people. If I can catch it early enough with medication (I'm lucky one works for me) it's not the end of the world.
The few times I haven't been able to get the meds have been the absolute worst pain. 10/10 pain scale, everything hurts, every nerve on fire. Not only is your entire body protesting its existence while someone is jamming a spike into your eye and wiggling it around while someone else is splitting your skull open with a something dull, but everything external causes extra pain. Lights hurt, sounds hurt, smells hurt whatever that means. It's the only time I've been suicidal if it meant ending the pain.
When someone tells you "Oh, I've had migraines they're not that bad I just try to ignore it" no, they've had a headache. Migraines leave you sobbing in a dark room hoping you die sooner than later. Do not recommend.