After trying some prescription drugs I've also found Marijuana works the best for me. It's the difference between lying on the bathroom floor waiting to throw up and being semi-functional (I am pretty stoned, so not totally functional) around the house.
I don't think it's a cure so much as a great way to manage the pain while the migraine is at its peak, unfortunately the migraine hangover still lasts for days.