It was never you. It was the delivery.
Every pill, gummy, and powder you've tried entered your body the same way: through your stomach, where acid destroys a large share of the active ingredients. What survives hits your bloodstream in one spike that wears off right around 3 AM. You didn't fail those products. Those products failed you, for the same structural reason, every time.
Change the delivery route, and the night finally holds together.