As has been said, there really aren't any "light" .40 factory loads. However the most forgiving loads are the 180 gr FMJ loads. If you want to shoot light loads, your best bet is to get into handloading, which will also save you money, or at least allow you to shoot more for the same money.
Based on DATA
Harder kicking 40 S&W loads:
Glock 27: Ranger T 165. @ 1,116 fps = PF 184
Glock 27: Speer Gold Dot 155 @ 1,171 fps = PF 182
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
"Softer" kicking 40 S&W loads:
Glock 27: Remington 165 GS @ 1,018 fps = PF 168
Glock 27: Federal 155 gr. HS @ 1,072 fps = PF 166
Glock 27: Federal 180 gr. HST @ 930 fps = PF 167
PF = power factor and it is useful for quantifying recoil out of same size pistols.
Bullet weight x bullet speed / 1,000 = PF
Regardless, the 40 S&W will thump you more than a 9mm
Glock 26: Winchester Ranger T 127 gr. +P+ @ 1,182 fps = PF 150
The so called "snappier" .40's do not seem to bother me no matter what grain. I have the Glock 23 and have shot it many many times. Maybe since i regularly shoot my S&W .500 magnum with the big 500 gr. rounds all the .40's seem about like a .22. :image035:
Trade it in and get a Px4 Storm in .40S&W and recoil is extremely manageable..
Comparable to a 9mm