I have on my list of research topics to look at dive bombing accuracy over the course of the War.
For the USN, it seems in 1942 with Lundstrom's "First Team", one squadron of SBDs could disable and or sink one CV. In round numbers, in 1942, one carrier air group had the ability to sink one carrier. Then in 1944 during the Marianas, the ratio of USN CVs to IJN CVs was staggering in the US favor, the USN did not seem to have the same ratio for bombing. Whether it due to less trained pilots or better defense by the IJN, the ratio swung to the defender. At Midway, pilot training was everything. The Marine aviators flying SBDs from Midway didn't have the dive bombing experience of the Naval aviators and their score reflects this. Hornet's air group performance at Midway is an example of training and experience mattered more than aircraft type.
The Germans had very high hit rates with the Stuka in the Mediterranean, there was previous thread where a poster listed Stuka hits and kills in the Med, and argued the Luftwaffe was the highest scoring plane for plane of any air force against shipping.
This paper is an interesting Monte Carlo simulation of Midway.
https://www.researchgate.net/public...he_Battle_of_Midway_A_Counterfactual_Analysis
The authors simulate a "good" Hornet air group and if Zuikaku had sailed with Kido Butai.
As for the best dive bomber crews, Richard Best is to my knowledge the only pilot during the war to score hits on two different carriers in one day. He has my vote for the Best.