I have, and have always had cold feet so I wear tights nearly all the time, under trousers as well as dresses. Sheer ones in summer, thick thermal ones in winter (and socks, but that is another story).
If I find that one make are too short I throw them away and try another make. M&S used to be awful for having tights that were designed to fit only women with very short legs. I am quite long in the leg and have always found John Lewis tights fit, ditto Superdrug.
Surely the answer to the OP's problem is to choose elegant trouser suits or mix and matched elegant trousers and jackets for occasions like weddings, funeral and their like.