I found the only pair of leggings you'll ever need. Hint: it's not the cheapest option, but this lululemon pair truly goes the distance!
https://www.usmagazine.com/shop-with-us/news/best-leggings-at-lululemon/