Home Defense Handgun
But my situation is slightly different from most, I am retired and need a handgun strictly for home defense. No target shooting, no competitive shooting and no conceal carry.
Ok, you have decided that you want to limit the discussion to handguns.
Consider your level of skill with both handguns and defensive tactics.
Generally speaking it is easier to become competent with a revolver than with a semi-auto.
Consider how much time, effort, and money you are willing to invest and what level of skill you seek to attain and maintain. Keep in mind the rule of "If you don't use it , you lose it."
Since you have ruled out target shooting, competitive shooting and conceal carry; that opens your selection to the larger more massive handguns which can be a plus to control recoil.
If you consider the range of defensive cartridges available to you, you may think about .38 special, .357 mag., 9mm para, .357 Sig, .38 Super, .40 S&W, 10mm auto, .41 mag. (reduced loads), .44 special, .44 mag (reduced loads), .45 GAP, .45 ACP and some others I have overlooked. There is not a huge difference in the ability of the above referenced defensive cartridges to cause incapacitation in a determined attacker. All defensive handgun rounds are under-powered, that is why we are trained to fire twice to center of mass, assess and proceed as necessary. Cost per rounds can be a deciding factor. Difficulty of accommodating recoil can be a deciding factor.
There are dozens of quality handguns available which chamber the above mentioned cartridges. There are many loads with different hollow point bullets and non-hollow point expanding bullets available in the above cartridges.
You do not mention your location. Depending upon your level of skill and knowledge, you may want to consider taking some instruction which covers not only the physical skills used in defensive shooting; but also the legal considerations in your state. Some municipalities add more restrictions.