I’m weirdly picky about tights. I’ve had Ariat, Irideon, Kerrits, Tuffrider, For Horses, Free Ride, Esprit… and probably others that I’ve long since forgotten. The only ones I’ve kept have been the Free Ride and the Esprit. The rest just didn’t cut it for various reasons. The Ariat never fit me right and the fabric wasn’t my favorite, the Irideon were just meh in every regard, I hated the waistband on the Kerrits, the For Horses were SUPER comfy but not even remotely flattering, and I thought the Tuffrider were terrible quality. Full transparency - I used to work in a tack shop and have done a ton of breech and tight reviews for my blog so I’m basically trained to be overly critical at this point. 
The Free Ride probably have the closest to “nice yoga pant” material IMO. Super stretchy, super comfy, lightweight, good pockets. They are a higher rise and the full seat is very mildly grippy. Downsides are they’re maybe not quite as flattering as some others, and there’s definitely no structure to them if you desire anything like that (I like A LITTLE at least, but your opinion may vary). To me these are the pants you live in during the summer - cool and comfy.
The Esprit (I only have the PRO model, not the regular, so my comments are based on those) have more of a proper breech look to them, with all the detailing and the faux pockets. The fabric is silky and smooth like leggings, but put a belt on and you def would never guess they were tights. I also like the inner liner, it makes them more flattering and gives a little bit of support. The rise is more of a lower mid IMO, and the silicone seat is a little more grippy but not tremendously sticky (I would not wear them if they were, I don’t like posting out of my pants
). These are the ones I would buy if I wanted super comfy pants that were still very appropriate for lessons or whatever else.