Getting on with stuff isn’t possible with mine. The pain is considerably worse than any physical pain I’ve ever experienced (that’s no small statement) and the mental disorientation you mentioned is very severe, usually for about six hours. The visual effects, when I used to have them, were relatively benign. I kind of miss them.
I’ve had dozens of different medications; the only things that work for me today are sumatriptan succinate and/or extremely powerful narcotics. The latter carries a high risk of addiction so I have to be very careful. At one time, ponstel (trade name for mefenamic acid) worked marvelously, but I slowly became immune to that over the course of several years. I still recommend ponstel to people with migraines; if it works for you it’s relatively inexpensive (and the prescription doesn’t draw government attention the way high dosage narcotics do). Watch the dosages, though; it’s potentially as liver-wrecking as tylenol.