I agree with Ben, 7 seconds per shot is the max you usually want to show a clip. There are exceptions, such as if the long shot adds something. For example, a fly over something of interest or a fly back and out to show perspective. Even then, you may want to speed up the shot to be around 7 seconds. You can also cut the clip in those situations which creates a jump in the same scene. You can also consider using the special flight modes to make the clips more interesting (POI while climbing, POI while elongating the circle, etc.). Another idea might be flying sideways past something while close to it. It comes into view quickly and it quickly out of frame.
It will sound strange until you make a lot of videos but you always want to tell a story in a video. You will hear this a lot. What that means is that you want to _lead_ the viewer in some _direction_. It's more of this "direction" than a "story". I think this is where the art and experience shows. You can watch a lot of vlogger's who use drones as good examples of what is possible. There are even a few aerial shows on Youtube that can give some insight as to what looks good. I tend to also mix clips from a land camera with drone footage.
Some people just want to take some clips and put them together. That is great as well. For me, it also gets me out of the house and to places I might not have otherwise gone.