Having played a lot of different sports in my life I feel like I have a pretty solid grasp on the quality of a workout.
Having done MMA, I would have to argue that bodyweight training is the best.
We evolved to use our bodies. Playing sports replicates that activity our ancestors used to get chasing game and fighting one another.
We didn't evolve to jog long distances. We would walk mostly, and sprint when we needed to (like after prey or away from predators).
We didn't need to be able to lift hundreds and hundreds of pounds if we could move through and interact with our enviroments athletically.
This is why I would say, if you're looking for the best workout, play an intense sport, do crossfit, or take up bodyweight training.