The time of day will greatly effect the look of the images. The project's location, orientation and weather conditions must also be taken into account. Every project has it's own set of considerations and what looks "good" can be very subjective. Please take the lighting condition into consideration when determining what time is right for your project.
Sunrise is often optimal for Boston since the sun rises over the water. The sunrise light quality is best seen from 15 minutes before to 30 minutes after sunrise. It typically has less of a golden quality than sunset and the winds tend to be lighter than in evenings. Occasionally there is fog that blows off when the sun rises.
Note: the images below are video stills.
Midday light is often requested when the client prefers the subject to be bright. It is known by photographers as the harshest light with the greatest contrast of bright highlights and deep shadows. This lighting condition can be good for commercial properties when all the areas of the subject must be bright.
The "golden hour" is highly sought after by photographers and filmmakers for it's beautiful quality. When there are clouds in the sky, they often turn bright colors. Looking into the sun will give you sun flares while looking away from it may give you harshly lit sections. This look is best suited for drammatic scenes but may not be the best if you want everything evenly lit.
If you want the city lights along with a bit of sky, the best time is immediately after sunset during the "blue hour". The drawbacks of twilight shots is that the ISO must be raised in the camera, minimally degrading the image quality.
Note: It is only legal to fly a drone 30 minutes after sunset, limiting twilight operations. For helicopters it is legal any time of day or night.
Cloudy, hazy and overcast days are perfect for even lighting. It may not be the most exciting looking scene but everything will be lit properly. It also doesn't matter as much what time of day the shoot occurs. These conditions are often preferred by real estate.