[DJI Air 2S, 22.4 mm f/2.8, Mode = Manual, ISO 840, 1/8, ƒ/2.8, (35mm = 22)]
I believe one of the best times of day to take photos outside is Twilight. Compare this top photo to this one from a different time of day.
This can be summed up as the difference between everything in the photo getting the same amount of light or, like a spotlight on the stage when you light just some of the scene is more appealing.
Again another Drone shot from a different perspective and different time of day to compare.
Another difference is the type of light during the day also can make a difference. This one below is with tiny clouds. The one above it is with cloudy conditions.
My suggestion is whenever you can take pictures at twilight.