The horizon always rises to the eye level of the observer as altitude is gained, so you never have to look down to see it. If Earth were in fact a globe, no matter how large, as you ascended the horizon would stay fixed and the observer / camera would have to tilt looking down further and further to see it.