We went through similar search and settled out on:
1. The Estrace Ring. https://www.estring.com/ Much less messy than estradiol cream; and
2. Sliquid Organics Natural lubricant https://sliquid.com/shop/sliquid-organics/organics-aloe-based/natural-sliquid-organics/ ; and
3. The Lube Launcher https://www.organicloven.com/lube-launcher/ when we are planning prolonged playtime (to place the lube well into the vaginal vault).
Is the discomfort vaginal, vulvar, or perineal? It's not uncommon post menopause to develop some chronic inflammation +/- dermatophytes (intertrigo) in the moist crevices adjacent to the introitus , and if present that issue has to be considered separately.
We went through a range of lubricants before finding the least "chemical", most "natural" product that has worked perfectly.
Pro Tip: Lube gets spilled and fluids flow. The Liberator Throw https://www.liberator.com/fascinator-throw.html is soft, absorbent, does not leak, and softens further with washing. They stand up to frequent use and being thrown into the washing machine. A few around the house promote spontaneity, they look perfectly in place over the back of the sofa, at the foot of the bed , on an easy chair etc. We are customers of Liberator products but have no other relationship with the company.