Just to be clear about something. When I hear the word "tights" I can't help but think about what I see the girls wearing when you go by a ballet studio or see some old video from the 80's when woman paired leotards with tights. These "tights" are little more then colored pantyhose...they're shear, semi-transparent and NOT what men wear while jogging, riding or exercising.
Just to be clear....the stuff men are wearing is much different then a thin layer of "hose"....the material is generally thicker, offers muscle compression, warmth and performance qualities.
Just a few days ago I went for a solid ride on the bike...the weather was a bit chilly. Choosing the right 'gear' is always a bit tricky because you get warm riding, but the air can be cold....so it's a mixed-bag of climates. I went with some bib-knickers, which is basically just a regular cycling bib with 3/4-length "capri" length on the legs. It feels like it's lined with fleece..a really nice thin layer of material. It was perfect...solid compression, warmth, breathability and mysteriously unimpeding in movement.
After the ride my wife called to say she was having lunch with a friend RIGHT NOW and come if I wanted. It was sushi, can't pass that up. The odd thing was that my wife's (very attractive) friend was wearing her black spandex capri-length gym 'pants' and we both kinda looked like twins. Not a big deal. On the way out, in the parking lot, she even commented on it and said she wished her husband would wear the same thing...but then said he didn't ride and didn't have the legs to pull it off. LOL.
Again....most woman really don't care or notice but there are definitely a solid percentage who seem to have an appreciation for it.