I have a Remington 870 in the bedroom closet and a Kimber TLE-RL2 .45 that I keep in a lock box in my nightstand for home defense. I carry the Kimber on occasion, but it is heavy. My main carry pistol is a Sig P938. I DON’T leave my home without it. It is very light and concealable, yet extremely accurate and dependable. It also has a price tag that starts around $750 new, but quality isn’t free. If you are going for home defense, you can’t beat a pump shotgun. When your adrenaline is pumping, a gun that doesn’t need a marksmans aim can and will be a life saver.
When buying a pistol, another thing to ask yourself is how many rounds does the gun need to hold? If you are using it for home defense or a range gun, you probably want a double stacked magazine. This will allow you more rounds (usually anywhere from 10-24+) but will be a bit thicker and bulkier. If you want a carry pistol, a single stacked magazine is much easier to conceal. I agree with many of the posters above in that you should definitely go shoot as many pistols as possible before making your purchase.
One last thing if you are going to be carrying concealed. A high quality concealed carry holster is worth 100x its weight in gold. If you go the cheap route, you will end up spending more on different holsters that never fit or feel right. I recommend both Crossbread and Comp-Tac inside the waistband holsters. I have had great results with both. Good luck and congrats on your future purchase!