I'm not confused
With a CNC machine, Spindle has the ability to move in many directions like the video below
With a manual milling machine it is easier , the spindle part is usually fixed or fixed after adjustment and it will be exactly where it is , and if the machine body is rigid / strong enough and the parts are Its other is correct and make it right then borehole is correct for need
It doesn't matter to me fixed workpiece or rotating workpiece , because I have done both , depending on my needs , capabilities .... of machines , tools ... and I will choose which method is the best with workpiece