The 40 will have a good deal of recoil no matter what, it the nature of the load and it's power. In turn, most folks won't get the same groupings with a 40 as they do other calibers, which is fine.
The cartridge allows it to be used in smaller, short cycle guns, which is again a strenght to the design. It does allow for more rounds to be crammed into the gun, except for the capacity laws.
I find the Sig 40's, the 229 and the 239 to be my favorites. Both have some heaft to the slide that aids in recoil and controlability. I use the 239 as a CCW quite a bit I trust it that much. I have an older shorty fourty performance center, and it has nice high caps, but is on the verge to too finely tuned for the stress of a live fire situation.
I have owned three Glock 23s, and as mentioned, it is a matter of choice. I still have one, and it is in the bottom of the fishing tackle box.
I have tried the USP lines, and as much as I wanted to like them, the actions were dissapointing to me.
The fourty is a sound and intelligent CCW choice, as it is in small packages, and will do the job without question in two rounds or less.