@christiansince94 So I haven't tried any of the trendy legging brands recently discussed, but over the years I've used the following: MEC, Craft, adidas, Tasc, Gap, Eddie Bauer and Urban Outfitters. None were completely satisfying - some didn't stay up, some rode up, some got see through and some just weren't very comfortable.
On the other hand I got my first Lululemon yoga pants in 2003 and abused them until 2008 when I was forced to admit they no longer fit (a girl's body changes a lot through puberty). My second pair held up perfectly from 2008 until I retired them just a few months ago. That's a decade of wear and ignoring the washing instructions without issue. The first pair pilled a bit, but the second pair only ever showed some cracking on the reflective bits.
So when I had some extra money to spend two years ago, I decided to go with a brand I trusted and bought a pair of Lululemon leggings. They instantly became my favourites and other leggings only got worn when required. Within a few weeks I had splurged on a second pair. Yeah they're more expensive than other leggings, but when I consider their cost and how often I use them compared to jeans, bras or running shoes they don't seem obscene. I'd rather have a couple of nice expensive pairs than ten cheap pairs. I'm sure I could find something more affordable if I searched, but I'm not sure the process of finding them would save me any money.
All that said I wouldn't really consider these leggings worth it if spending $100+. They always have some discounted on the "We Made Too Much" section of their website, so paying full price seems like a waste of money in comparison. Right now the ones I like are $70 in CAD, so probably $50ish in USD?