https://www.vcalc.com/wiki/gun-recoil-velocity
I used this calculator to make an excel file of lots of handguns that I had personally owned or shot as well as others I was interested in.
I used the criteria of anything with a recoil velocity over 14fps as questionable and anything over 15 as problematic and anything 16 or above as no way.
I could then sort them by weight or recoil velocity and look for the "sweet spot" of weight and recoil.
It isn't 100% accurate to my experience but it it reasonably close. For instance a G19 with 124gr+p GDHP rates 14.63. Which isn't painful but not a all day long shooting round.
While the same round in a G43X was 18.49, which was painful to me.
A 115gr target load rated 12.51 (shoot all day) G19 and 15.81 in a G43X which is the uncomfortable but not painful range. I started having recoil hand shakes before 100 rounds when I had one.
I just used published recoil velocities that I found on the internet and unloaded weights for simplicity. So the velocities are likely too high on the smaller guns and the weight is too low but I think the error was similar enough across everything to give me a decent idea of what I should expect on recoil.
However, it does say that a Walther PPK should be 11.2 and I hated shooting the PPK I used to own. I shot a whole 100 rds out of it the whole time I owned it, I would be surprised.
Nothing scientific, just a evaluation tool to narrow down what I wanted to look at before I make the 1 hour plus trip to a rental range to try something out.
I apologize in advance since I am typing on my phone instead of a real keyboard because work now blocks PF.