Johnson's Dreamy Skin hand lotion definitely works best at night. It has a lovely lavender smell which lasts all night until the following morning, and I have found that the lavender also helps me sleep better.
It has a thicker texture than other creams I have tried so that you can feel it working on dry and irritated skin, but because you are asleep when you use it, it wont cause slippery hands like alternate hand lotions applied during the day.