On this point… I’ll say that, for $700, you can get a great, no-compromises service pistol. You can pay more, but you really don’t need to. Buy a Beretta 92X RDO or a Glock 19 MOS or a CZ 75D PCR. The benefit of a $1500 pistol is minimal over a $700 pistol—they’re more for perfectionists and enthusiasts. 99.9% of people are better off buying a $700 pistol, 2 cases of ammo, and some training. Personally, I’d just buy nice and be done with it.
When you go to a lower price point, things get more complicated. You can find the Glock 19 for $499 (an older version, without an optics cut). You can find a CZ P10C for $380. You can find a CZ P-07 for $460. A SP2022 can be had for $490. These would all be fine choices.
But at that price point (especially sub-$400), you have to be much more selective. There are a lot of options that may be fine for enthusiasts looking for a range gun, but that you shouldn’t consider as your “one gun.” I wouldn’t advise you to choose a Taurus, a Kel-Tec, an SCCY, a Canik, etc. You want a trusted, known model… You don’t want to play the lottery.