I've had a similar fascination about maximizing beautiful sky shots with my
Mavic 2 Pro here in Hawaii. I'm entirely self-taught so I know I'm no expert, however I think I've created some great pictures using full manual panoramas, (manual control of both the camera and the drone) usually with AEB shots, and often as a two-row panorama. As others have mentioned the one-button pano mode is great for a quick shot but to really get everything into a single frame it takes manual control, particularly over the drone and gimbal.
These three shots below outline one of my earliest experiments in trying to maximize a sunset. BTW, this first shot is unedited, not AEB, only modification is a white balance preset (cloudy, I believe) within the drone's camera itself. It demonstrates how limited the view is in a single shot of a sweeping sunset, but also shows the gonzo colors of a Hawaiian sunset:
Then increased into a single row panorama with the camera tilted up significantly above the horizon (but not all the way up to 30 degrees, as the land would be mostly/completely chopped out). This one started with four overlapping AEB sets, or 20 original pictures:
It's a compromise because I'm still missing some of the color beyond the top of the frame and the slice of land at the bottom is mostly an abstract streak. Two days later I made my first two-row panorama, similar horizontal framing but now created from eight overlapping AEB sets, 40 original pictures:
Now I'm able to capture as high as 30 degrees above horizontal (depending on the angle the wind is hitting the drone) and as low as I want to capture anything on the ground as well. As the original shots are such high quality I can still zoom in on any portion and get nice detail.
Anyway, it's worked out for me. Once I'd practiced it a bit it's easy to fire off a complete two row panorama (even three row a few times) is just a minute or so, with up to around 10-12 AEB groups (50-60 shots total) in a two-row panorama.