Good Morning, I am a nurse and specialize in infection prevention so my hands have had years of wear and tear.
I agree that product that leaving the hands sticky and greasy are not comfortable. You might want to use products that are more comfortable during the day but change to heavier or thicker product at night. Always clean your hands before applying any hand lotion or cream. Wash your hands and gently pat dry your hands. Then apply the product on those freshly cleaned hands then go to sleep.
During the day I use a generic fragrance free moisture complex, about $3 for a huge bottle. At night I treat myself to 2 pumps fulls of Crabtree & Evelyn Gardeners Hand Therapy. What a wonderful scent that helps me realize it is time to sleep--just my habit that triggers my brain each night signifying it is time to sleep.
I wish you well with your hands. Happy New Years, Karen