This goes back to the Atari 2600 days. Games like Frogs & Flies and Real Sports Volleyball had skies that darkened as night fell.
A little more modern, sometimes I like to just drive around in Need For Speed Hot Pursuit on the PS3 to watch the sunsets turn to night and back to dawn again.
And of course, being a life simulator, The Sims games had great day/night transitions