LOA - more headache or beneficial in getting your HA life back on track?

I am 36 and have had chronic severe migraines for over 20 years with some of those years being more medically successful than others, though for the past 6 months to 1 year I seem to have more bad than good days. I have a very supportive and loving husband who does his best to help take care of me when I can't take care of myself but I know it's weighing on him both physically and emotionally. My entire family (biological and in-law) is very supportive which has kept me from going completely crazy.

I currently work in a Sales environment & have been here for over 5 years. I love my job, esp since it's never dull and they have always been willing to work with my health issues, but it is a high stress atmosphere and while it may have been OK for a few years I need to reevaluate. Over the past 2 months I have been out more days than I've been there and even when I am at work I'm not high-functioning so my teammates are feeling the pressure too. I'm at a loss for what to do because right now I can't continue on this unproductive path both medically and career speaking.

I am seriously giving a lot of thought to taking a LOA though I'm afraid that if I don't have a job then it will take my motivation to get out of bed and actually try and do something. I'm also concerned that if the Dr's haven't find the right choice of meds yet, then how long is that whole process going to take? But maybe if i don't have a FT job to shift my focus then I can fully devote to getting better and figuring out the right course of treatment/medications. I'm not expecting an answer overnight but I want to see a light at the end of the tunnel and right now all I am doing is digging myself deeper and deeper into my headache pit.

This may be a long rant/post and while it may sound depressing, I really am trying to find my joy and life again and would welcome suggestions that others have in exploring the LOA route or just continuing to call in sick?