I am so sorry this is happening to you. I also have extremely bad migraines. Have you gone to an ENT? I ask because sinuses could be an issue. I found out most of my sinus cavities are so narrow, that fluid builds up behind my eyes and face causing migraines. ENTs can perform outpatient procedures to actually widen the cavities now! It’s a one-day operation with two weeks of downtime.
The other thought is botox. Have you explored this option? It can be covered under your insurance for migraines. I totally feel you about not wanting to take too much excedrin. It also has caffeine in it which is obviously not something you want to do at night.