Nowadays 147gr is my 3rd choice when it comes to bullet weight. I carried it as an issued and off-duty load for some years, though, before we switched to 127gr +P+ and later 124gr +P ... and then eventually back to 147gr. I dabbled with some 115gr +P+ somewhere in those years, but mostly used it as range ammo and didn't carry it. After so many years of using all of it for training and practice as an instructor, in 9's with barrels ranging from 4", to 3 1/2" and 3", I can't easily tell the difference in felt recoil and cycling most of the time ... except for the 127gr +P+. It has a bit more snap and bark, especially in the 3" gun, if you're taking the time to perceive it.
Preference-wise, I prefer to carry the 127gr +P+, for it's brisk cycling and the stellar reputation it earned over the years among LE users. My second choice is the 124gr +P. I still have a couple different vintages of 147gr SXT & T-Series, as well as some HST. I haven't tried any of the 147gr Ranger One or the latest version of the G2, yet.
Hell, I've even got some remaining USA 147gr JHP left over from the years when it was really cheap to buy. I mostly keep that for range fodder.