Ok, I tried to make this short, but it did not work. Short answer is, in my experience, given the same bullet weight, and similar pressure, faster burning powder produce less recoil, and less velocity.
I did some testing a couple of years back. I was shooting a Ruger LCR in 38spl with a 1.87in barrel. My goal was to see if I could achieve a full powder burn in that little barrel as I was getting massive fireballs and high extreme spreads due to the incomplete burns.
I tested with Hodgdon clays, HP-38, and Power Pistol. I did this with the same bullet, and all at max listed charge, so that should have all be about the same pressure give or take a little.
Found my testing results in my old thread
Ruger LCR chambered 38spl P+ (no +P loads used) with a 1.87in barrel.
Mixed 38spl brass
CCI #500 Small Pistol Primers
Brazos 158g SWC (hi-tek coated lead)
5 shot groups unless otherwise noted
Power Pistol (the one with a lot of unburned powder)
4.7g, avg 734fps, SD 4.35, ES 8 (4 shots, 1 registered at 13,000fps was removed)
5.2g, 804fos (only got 1 good reading, 1 error, 104fps, 99fps, 102fps, 804fps)
HP-38 (aka W-231)
3.1, avg 524fps, SD 22.6, ES 53
3.7, avg 652fps, SD 27.63, ES 75
4.4, Avg 739fps, SD 4.39, ES 11
Hodgdon Clays
2.8, avg 632, SD 12.77, ES 28
3.1, Avg 677, SD 14.17, ES 37
Notes,
Power Pistol had an unholy muzzle flash, Bright light yellow, about 8in in diameter and about 1ft long. Recoil was painful in the light gun.
HP-38, Has minimal muzzle flash, small orange fire ball, maybe 1in by 1in. recoil was moderate, not painful.
Clays. No muzzle flash. Mild recoil not snappy or abrupt. Could shoot these regularly in the snubbie.
https://thefiringline.com/forums/showthread.php?t=613662&page=2