The most interesting time of day for me to photograph is near dusk. The light is very soft and the details are revealed in the dark shadow areas that normally would be lost in harsh sunlight. This time of day is usually very still because the wind settles down after sunset and give the opportunity to make the long exposures required in such lighting conditions. I hiked along this stream just after a heavy rain and sloshed my way down steam until I came to a 80' waterfalls just beyond this big rock in the photo. It takes a lot of energy to carry the gear and heavy tripod with me on these hikes but the rewards of the experience and making some new images is always worth it.
John Sexton a friend and fellow photographer has produced a book entitled "Quiet Light" that has one of the best collection of photography in low light.

http://www.amazon.com/John-Sexton/e/B000APB7S4