I've got two of the Colt 10mm Autos, one a Gold Cup and the other a Combat Elite. They are definitely cool, but a niche article and probably never going to regain much momentum.
Think about it; you had the 357 Magnum, and then the 44 Magnum came along - a significant improvement, yet something the average enthusiast could actually bring himself to shoot... a few times, at least.
The 454 Casull and later "super handgun ctgs", while even more of a good thing, are just too freaking much to be considered after the first shot by anybody except a real gun crazy (not a bad thing) or a masochist. Let's not mention the price of ammo, either.
The 41 Magnum is an afterthought. A good idea, to be sure, yet there is never any 41 Magnum in stock down at the local hardware or WalMart, so everybody finally gets smart and gets a 44 Magnum for their big bore.
In the auto realm - the 45 ACP in its original Colt 1911A1 gained a fearsome reputation for mayhem - on both sides of the gun. While it spewed death and destruction from its sewer pipe-sized muzzle, it bucked, cut and pinched the hands of the shooter, as well.
The Super 38 was released with a keen understanding of the FBI's needs - shooting in and around automobiles and negligent discharges. While this was in the same 1911A1 package, the 130 grain bullet was fairly innocuous on the giving end, compared to the 230 grain 45 ACP of song and story.
The 200 grain 10mm was back to the horrifying experience of a kicking, bucking, and pinching 1911A1, especially with the abbreviated grip safety tang of the Delta Elite. We are back in the area for gun crazies and masochists, I believe. I'm not sure which category I'm in, but I have two.
The 357 SIG is basically a Super 38 that will fit in a 40 S&W sized gun. Not anything to write home about, imho. YMMV, etc.