If you must have a pistol, go with a standard size revolver (not a snub or "airweight" with a 4" barrel in .357 Magnum. The kick isn't bad in a standard frame gun and it hits much harder than .38 Special. Taurus and Ruger make inexpensive revolvers. Smith & Wesson makes expensive ones. They all work well. Fixed sights are preferable for home defence.
“Select a self defence load, though. Don’t use bird shot (#6 - #9).”
What do you consider a “self defence load”?