At night is best. I love settling in on a rainy night and falling asleep to the rain.
Afternoon rain coming in at #2. A favorite off-day for me is rain coming around midday, going to the movies, then it clearing up into a cool, post-rain smelling evening/night.