Brass Magnet isn't here as often as others.
As noted,, the burn rate charts are in all good manuals. The age of the manuals is something to consider. Older manuals,, will reflect the burn rate of the powder during that era. Many powders change in how they are made over time, and updated manuals are necessary to keep up with the upgraded powders.
As to why a specific powder would be recommended for one application vs another, all goes back to PERSONAL selections.
I study all load data from several manuals, and most often,, I see a pattern evolve. I look at the test firearm,, such as "universal receiver" vs. an actual firearm. It can make a difference. And when comparing a semi-auto vs a bolt action, you are dealing with different requirements for the ammo to be able to perform.
Peak pressures happen at different places inside a firearm, so it may be necessary to have a load that properly operates the semi-auto, vs a load that works well in a bolt gun.
And even with the current component shortages,, you can study several manuals to get a good idea as to what YOUR gun may find to be the better component starting place.
I never take internet load info as gospel. I do my own studies. And I stay within the perimeters of safety by following listed manual info.
So, since Brass Magnet hasn't responded,, maybe this post can help you in your quest. If I'm off base,, my apologies.