The lightest .40 I have shot is still quite snappy in a sub 27 oz. gun..I find most .40 just tolerable in a G22.
This caliber has ruined most compact and smaller guns up till now because they are built around .40 pressure and recoil instead of 9mm. (so their bigger than necessary)
Around here .40's have little trade in value especially small ones.
If it is going to be used for real stuff then a 9 is the "weak" load you are looking for.