Motion Tracking video tips
I think the best way to shoot a video is either by using a tripod and not turning the camera, which means you almost need to do no motion tracking at all, or you film it by hand and try to do it as smoothly as possible, any blurry frames mess up your trackers. or you just don't do motion tracking at all and try to animate the camera into the same position in the 3D viewport.