My personal favorite of all time is a Beretta 92fs 9MM
Your question is technically wrong. There are many different types of guns for different purposes. If you can define the specific purpose for the weapon, the question can be answered more appropriately.
As you have shown preference for Bretta 92FS, I assume you meant a hand gun for HD/SD purpose. For SD I prefere and use following handguns for SD and HD.
SD
1. Makarov (9x18) 7+1 round (3+1 mags). Compact, Reliable, Durable, Simple, Concealable, and pretty Accurate for its size, but slightly heavy.
2. Glock 19 (9x19) 15+1 (2+1 mags). Compact, Reliable, Durable, Robust, Concealable, Lightweight with decent Accuracy.
HD
3. CZ75B (9x19) 17+1 (5+1 mags). Full size, Very Reliable, Durable, Very Accurate, Heavy and Sturdy.