I LOVE my USP in 9mm. Ultra reliable, durable, and shoots about as straight as they come. They do run a little more, but if you can find a lightly used one like I did, they'll often run at a decent price.
One which I don't think has been mentioned yet is the FN FNX/S. I don't see these guns getting quite as much love as the usual suspects, but I'm not sure why. They've got great capacity, reliability, and accuracy. If you can find an old stock FNP, they're mostly the same pistol as the FNX, just without the same ambidextrous controls and interchangeable backstraps, and they run $100.00 less.
You won't be sorry with a 226 either.
Also, as many have voiced, the BHP is absolutely incredible.
"Freedom and reason make us men; take these away, what are we then?"
-Sometimes your best defense is a good reminder of your common sense-
HK USP Compact 9mm - SA XDM 4.5 .45 - Browning Medalist .22 - Ruger 10/22 - Browning Superposed O/U - Remington 1100 - Remington 720 .270