I'd like to better understand how capable modern Android hardware is for these computer vision tasks.

The only one I know of is Hooper (https://www.hooper.gg) for basketball analysis.