If top velocity is your goal, the powder that gives highest velocity in a longer barrel will also give the highest velocity in a snubby, regardless of how much powder is "wasted". Most of the time I find unburned powder grains to be more a sign of a weak crimp than insufficient barrel length.
Nothing could be further from the truth^^^^!!!!
Not only powder selection, primer selection for the powder/bullet combo, bullet construction/physical design, oal for the chambers in the cylinders & bullet diameter for those chambers all have huge impacts on velocity.
Then add in a jacketed/plated/lead & lubed or coated bullet into the mix.
I've cast and swaged bullets for the 38spl/357 for decades (5) and used those cartridges more than any other in revolvers. Mostly 4" bbl's or longer with 6" bbl's being the main lengths used/shot. Never gave too much thought about velocities per powder/bullet performance with those bbl lengths.
A couple years back I did testing with 10 different bullets (150gr to 160gr) in a snubnosed 38spl (2"). Used 5 different powders with those 10 bullets with max p+ loads. Only di 5-shot tests with each load/powder combo but the other end of the spectrum was that after 250 loads the same bullets always had the highest velocities.
As much as 70fps difference, that huge!!!!
From there I used 1 bullet and 3 different powders in a test using:
2400 VS H110 VS MP-3000
Used hot!!!! max 357 loads and used a 2 1/2", 4" (2x). 6" (3x). 8" & 10" bbl'd revolvers (10" was a contender).
At the end of the day:
the highest velocities were with th 2400/2 1/2" bbl'd revolver
the 4" bbl's were a wash/ all powders within +/- 10fps of each other
6" bbl's the h110 & mp-300 easily had more velocity (60fps+)
8" bbl, the h110 & mp-300 really started to shine
by the time the 10" bbl tested the 2400 wasn't even in the conversation & I was getting 1600fps out of that bbl with both H110 & MP-300.
I used a 170gr fn cast/coated bullet for the testing
That 2 1/2" bbl's revolver did 1200fps using that 170gr cast/coated fn bullet using a "max" load of 2400.
H110 & mp-300 were not only erratic in that short bbl, but they were also 50fps+ less in velocity.
Perhaps powder pistol, bluedot, AA#7,etc. would be a strong performer in the short bbl's. I was happy with the 170gr/1200fps combo and quit testing.
Pick the wrong bullet and the right powder and you're down 50fps+/- in the snubnosed/short bbl'd revolvers.
Pick the wrong powder and the right bullet and you're down +/- 50fps in the snub nosed revolvers
The 1st thing you should be looking at is bullet selection. Then oal for your revolver and finely powder