In the stores there may be a wide range of comfortable tights available, but you as a consumer should be very careful about the size and quality of the fabric. Look for smooth, sweat wicking fabrics. Leggings are something which you wear for a longer duration.
Kydra has come up with some excellent designs for comfortable tights, as they genuinely believe in customer satisfaction. They vouch for their product as they have been tested by their in-house team and athletes at all levels. You should focus more on its stretch ability rather than just going for the look.