Night cycles offer many opportunities for race/class specific characters. A theif for example is hardy going to sneak about breaking into homes in the city of waterdeep at noon. Given the choice a party of 4 is not going to charge into a heavily garrisoned goblin camp at noon. Apart from hundreds of things I could go on and on about from game mechanics to race/class advantages it adds greatly to the atmosphere as already stated.
