As a good ol farmboy, and a night security guard, I have come to have a few favorites.
On the job, in my regular uniform, I carry a Sig P-220 in 9mm (currently the only P-220s produced in the US are .45acp - mine is an older model from Europe). When I have to wear my "corproate" gear (suitcoat and collared shirt), I carry a P-229 in 9mm two-tone finish with pachmayr grips. the 229 is available in .357sig and .40S&W as well
In addition, I have a 16ga, a 12ga 870 pumpgun and a .410 shotgun.
The singular best home defense, in my opinion, is a vocal dog. Any "prowler" is going to think twice about entering a home with a dog yapping itshead off, no matter what size the dog may be. My American Staffordshire Terrier ( a 70LB "pitbull" ) is VERY quiet.. he'd apparently prefer to let you get in the house and rip your arm off his own self. This is NOT a good guard dog. You want a dog thats willing to make noise to alert you.
Finally, Im all for wheel-guns, as long as you have a speed loader of some type; HOWEVER, Im very sure my Sig is older than I am (Im 22) and its still as accurate as any NIB pistol. The last thing Id reccomend, is either A) practicing shooting in a cross hand stance, holding a small maglite in one hand, pistol in the other, or getting a weapon mounted light system.
In conclusion, a handgun is a huge commitment, especially if you have children. The best protector, aside from moving to a better neighborhood, in MY opinion, is a loveable, huggable german sheppard. God forbid if you have children, and one stumbled home drunk from a party after being dropped off by the designated driver, and you in a panic, accidentally created a much bigger problem. If you insist on getting a handgun, dont focus on ye old hand cannon... something that causes you to have problems with its weight or recoil... you cant shoot the target. Id much rather hit somene with a heavily loaded 9mm in the leg and have them leave while my wife is on the phone with the proper authorities... that blasting holes in my home and the neighbors. Most "shootouts" are a frenzied exchange of a few rounds in the dark anyway. Dogs dont miss, and as much of a part of the family as they become, they CAN be replaced... you or your children (if you have any) regrettably, cannot. I wont dissuade you from getting a gun. As an NRA member I firmly believe in your right to own a gun, even if for nothing more than blasting away at nefarious cans and bottles in your backwoods, but PLEASE think and choose carefully as people seem to only remember the mistakes and not the triumphs. Also remember that many police officers and war veterans struggle with taking another life, make sure this is something you are prepared to come to grips with, and be honest with yourself.
Good luck and keep us posted on what your decision is. Those of us that keep guns at home, heres to us never havng to use them