How to improve my camera controls to properly drag the camera around the sphere?

try checking this project that was shared by unreal staff on an old thread of mine. it has something similar with what you want to do