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.
Strive to always carry the gun you would carry on the "bad" side of town.
My carry philosophy is "Something is worth doing is worth doing right" not "Something is better than nothing".