All of my serious carry handguns are Glock 9mms and S&W J frame .38s.
We issue and carry Glock 9mms on my job, so I have a 17 on duty, a 19 off-duty, and a G26 sometimes as a BUG.
My S&W 642 or 638 are for BUG and/or off-duty carry.
The .38Special and 9mm work just fine with good ammo and good hits, everything works poorly with badly placed hits.
I use 124gr +P Gold Dots at work, Ranger-T and/or Gold Dots off duty. I most definitely stay away from "magic" bullets like MagSafe or Glasers.
This is a good read and reference on the issue of ammunition and caliber choice;
http://www.m4carbine.net/showthread.php?t=19914and;
http://www.m4carbine.net/showthread.php?t=19887...and a well written bit here;
http://www.snubnose.info/docs/No_faith.htm