I have tried both the rotation and translation control to manually fly a drone, so far.
For me, the rotation control felt a lot more dynamic and kind of reminded me of controlling drones or helis when playing a game with controller. I think it makes sense to use this for stuff like races.
The translation control is the one I used the most so far, though, because it's easier to keep the drone under control and not crash, in my opinion.