My Glock 23 and 27 do not suck.
A little bigger, heavier bullet with a little more recoil than 9mm in same size pistol.
If a 9mm is okay for SD, then an equivalent 40 is potentially better.
Criminals and psychos are mobile and my show up in "good" areas unexpectedly, carry accordingly.
Carry the gun you would you would prefer to defend your life with, in the off chance you have to.