I think its safe to say every single handgun mentioned in this thread is overrated in one way or another. Yet each fills its niche for whatever characteristics a particular shooter is looking for. Is that a broad enough statement?!
I love Colt 1911's, and I'm lucky to have a few that run just fine. I have no interest in any models made after the 80's though. Generally they are finicky. Buy an old used Series 70, have it gone over by a competent 'smith WHO KNOWS THE 1911 and I bet you'll be happy. S&W's line are nice guns but overpriced by at least $300.
Glocks. Besides the .40's, I'd have no problem trusting my life to one. Reasonable price, reliable, simple. Grip is crappy but I've seen worse.
Sigs. If I were Inspector Gadget and could telescope my neck to get a nice sight line, they'd be fine.
S&W's Walther products. Hey, S&W, stop. Really. Just stop trying. Carl Walther is rolling over in his grave.
Beretta M9. Although oversized and overengineered, a perfectly fine firearm. I had one and carried it on occasion for ~5 years but cannot comment on it's reported weakness to dust and grime as I did not carry and fire it in the desert or drop it in the dirt. I do know that many of our troops don't care for them. I think their opinion counts the most for obvious reasons.
HK. Expensive yes. Nice shooters though. I've fired a USP and liked it.
Ruger. I have 3 Ruger handguns. They make a fine product at a decent price. The magazine safety on the MKIII pisses me off though.
Desert Eagle? Right off the bat, the company name is pretentious. Almost more so than the gun itself. Pamela Anderson holding one is the only thing I like about the DE.
Kahr. I think they're underrated. Ingenious, simple design and are very reliable. IMO the trigger is the only thing that keeps it from being a perfect handgun. Forget about the new MA compliant versions though. That safety lever is f@ckin stupid.
What have I missed...