I get horrific period pain, to the point of vomiting and needing to be in bed almost all day tried everything. The pain is mainly in vaginal area?

Hormone imbalance. You may have high estrogen (e2) &/or low Progesterone (pg). The high e2/pg ratio causes a parasympathetic(pns)reaction in your autonomic nervous system. Pns causes contraction of your smooth muscle (cramps), stimulation of your GI system (n/v), your body excretes e2-liver detoxing via an enzyme named glucuronidase. Calc-d-glucarate, pg, & low carb diet may help.