Jakearoo:
I am both a collector and avid handgun user so I'll answer your question two ways.
Colts and Lugers are my primary collecting interest. I have,for example, several 38SPL Colt Officers Model Match revolvers that are collectible but can still be shot. These target pistols were hand assembled and hand tuned in the good old days of firearms manufacture here. I doubt if we'll ever see the likes of them made again as the expense would just be too high.
My working guns are a different matter. I usually carry a Beretta Model 96 in 40 S&W. This pistol is considered somewhat antiquated by many but it works well for me. In the warmer months I sometimes carry a S&W snubbie as it can be concealed even if you're in shorts and a tee shirt.
If I were to buy a new working handgun it would probably be one of the H&Ks or a Sig Sauer. I get to shoot just about every new pistol that comes on the market at the Scottsdale Gun Club and these two are my favorites.
I hope this helps and If I can answer any other questions I'd be glad to do so.
Jim