My DH loathes tights, but I do wear them with a short skirt. There was a time when I would wear hold ups but spend most of my time in jeans/combays these days so no call for them. I don't think they look great but the keep you warm.
DH doesn't like them either. I don't wear the much but sometimes under skirts - IMO looks far better than white legs sticking out instead. If I am going out 'proper' - meal, ball, party, etc. I do make the effort to wear hold ups or stockings though.
DH HATES them, especially if they're not long enough in the leg and the crotch bit is too low . ICK. DH is a stockings and sussies man (show me a man who isn't), but I feel a pleb in them. I do like hold ups though.