I started getting them a lot two years ago. There was one time where I couldn't remember anyone's name. Flashy lights and numbness. It makes you think that you have a brain tumor or something.
I figured it was either stress or diet pop. So I learned to relax more and stopped drinking diet pop (and gained 20 lbs, crap). Thankfully, I haven't had a migrane in about 6 months. I also stretch my neck a lot to get rid of the kinks and tension. Its working good for me so far.
As far a drugs go, over the counter stuff is useless. I've used both the Imitrex pills and shot since I have insurance. Nothing works better than the shot. It sucks sticking that stat dose in my leg though.