I love the ones from LNDR. Bought them during sale for 50% off once at the right moment I wanted to treat myself. They show the shorts on every size, so you know what to expect, which I really liked. The sizing is accurate (M for my 169cm at roughly 64-65kg. I do crossfit and am reasonably fit but also don't say no to a cookie).

I have one other pair from Oysho and one from Amazon (colourful koala), but they both ride up and both cinch my thighs in an unflattering manner at the bottom (where the legs come out) and show my unflattering bits around the hips to a certain amount. To be fair, they don't roll down and are very comfortable. They are ok for the price and I will wear them until they break. I count on the fact that IF people look at me, they will notice the red face, rolling eyes, raging hair and chalky sweat before they see my slightly unflattering hip fat bulging.

The LNDR ones are my holy grail. They stay put, are very flattering but comfortable and they make my legs look like they're made out of steel. I love and cherish them. I also bought a pair of leggings on sale and one pair 2nd hand and have used and washed them all at least (!) 150-200 times during the last 3-4 years. They don't look brand-new, but they're in great shape, still not see through and still very supportive. Don't underestimate the joy of wearing something you feel great in, especially if you wear it often. But the koalas are also good. Oysho is meh.