Great topic, so many scientific formulations, BUT everyone is forgetting to take into consideration the gun itself, metal or plastic how it's sprung not just the slide but also the main spring, also persons body weight.
If you need more energy to unlock and move the slide past the hammer then you will have more felt recoil. Next to consider is the powder not just how fast or slow but also how fast it pressure peaks, this is in conjunction with the bullet weight and making minor or major, shooting Standard or Open. Of course if a comped gun for major only a light bullet with slow powder within reason will do, as you need the gas and particles to work the comp.
Speaking only from my own experiance with some of the loads I've worked up over the years such as.
In a 45 ACP out of my Colt Gold Cup 15 lb spring with a 19 lbs main spring.
Clays does a good job with the 200 SWC and 230 FMJ.
Tightwad does to me a bit better job with the 200 SWC but not with the 230 FMJ. Both are fast powders but the diff lies in the pressure peak. Using the same charge say 3.7 grs the Tightwad will drive to a higher Vol but is about peaked out. The Clays does much better with the 230 FMJ. This relates to the perceved and felt recoil as I see it.. We all have a different perseption what is recoil.
And yes, shooting Std. in general the heavyer bullets as per caliber will prefer a fast powder but at what pressure peak.
When it comes to the light bullets,as per caliber some of the faster powders do work but using some of the medium burn powders ( not slow ) can do a better job with felt recoil. As stated above when it comes to comp loads everything changes.
I can do pages and pages of loads I've used but that's up to the each person to decide what he likes best. I know what I prefer and usually works for others.