My name is Dan and I am new to this site. I saw your post and thought I could give you some insight on Botox. My wife has been receiving Botox treatments from the Cleveland Clinic for approximately 2 years now and so far we have seen mixed results. Overall, the treatments have been positive. It is true that when the Botox takes effect, she experiences long lapses between migraines (8-12 weeks). And if she does get a headache, it is far less severe and only lasts a few hours VS several days. But it is also true that it is expensive and is often not covered by insurance. She gets about 3-4 treatments a year. This adds up pretty fast.
As for the procedure, she receives about 4-8 shots in the back of the head and neck and several shots in the forehead. She says that they can hurt, but the doctor gives her a local anesthetic (cold nitrogen spray) to help reduce the sting. It takes up to a week for the injections to kick in, so do not expect immediate results. On several occasions, the treatment caused a migraine or made the migraine worse before it eventually got better. The best thing about the treatment is that, after the first week, she experienced no other side-effects... unlike many of the drugs she takes.
Let me know if this helps or if you have any other questions or concerns.