I have used my Mavic Pro a couple of times- but only with letting the drone "follow" automatically- (I am the drone operator, but either skiing or driving boat) the big limitations for me have been:
1.) Drone has trouble keeping up with boat. Advertised top speed is 36mph- actual is around 33mph. Downwind passes at 32mph work ok, but drone fades into any slight wind.
2.) Battery life: at about 30 mins maximum- and wanting to start process of landing (in boat- shore would be easier) with at least 20% battery as reserve it makes for a pretty quick ski set. But again, this is with only 2 people - so I launch drone, get wet, ski a couple of passes (spinning on ends to save time), climb out, catch drone.
3.) Tracking: optical tracking is useless because it will not really stay locked onto the changing shape of the skier/spray- and even with a good lock the drone would try to fly the skiers path instead of just following boat ....you could lock onto boat, but then you might not even see the skier because the camera is centered on the boat. My solution for this is a 3rd party control app that allows the drone to follow the controller (in boat) using GPS (from phone attached to controller)- you can then set a subject offset to pan the camera to the skier area behind the boat (instead of keeping boat in center of frame). This works very well, and you can set it and forget it- boat driver only needs to monitor drone battery level.
here is a little sample video- at the end I had the subject offset set incorrectly as you can see that the skier is just out of the frame:
If you have a dedicated drone operator that is not skiing or driving the boat then you obviously would have more options.