I suspect you weren't taking advantage of the MotorPower calcs available in CsvView/DatCon. E.g. Motor:Watts:Avg:All is smoothed power signal for the motors. To include the MotorPower calcs go to the menu bar and select DatCon Fields -> MotorPower. The pitch signal shouldn't be too noisy. Here is an example of some data I took when trying to figure out the wind calcs that are done on the Mavic (and other platforms) and then recorded in the .DAT. There are 4 cycles, each with 1) a leg flying away from the HP with full elevator, 2) some rotating to gauge the wind speed, and 3) a leg returning to the HP using RTH. Here is one of those cycles. Outbound has a ground speed of 9 m/s, pitch -9.3 and motorWatts 81. The teal background represents the RTH where ground speed has increased to 10, pitch to -13.5, and motorWatts to 86.
View attachment 30949
That's best looking cycle and is the 2nd out of the 4 cycles. The first 2 cycles are the same path out and back, while the last 2 cycles were a path ortogonal to the first 2.
View attachment 30948
Note, that the ground speed under RTH is always 10 m/s but the pitch and motorWatts varies to meet that requirement.
This data/experiment isn't quite what's needed to answer
@Dronedevices 's question. But, it could be a good start.