IME the curvature isn't really discernible until far higher altitudes. Most of the "curve of the earth" shots you see are because someone stuck a go-pro on a hiball and a combination of haze and fisheye effect makes the earth look round. If you use a camera without the lens distortion it just looks like a normal horizon.