As far as "official" handguns, basic P226 in 9mm is issued, S&W 686 4inch for dive ops, H&K SOCOM for close quarters and silent usage, and occasional M11 Sig 228 and M9 Barreta 92FS. Otherwise there isen't much else that they use. Theres plenty of guys have chirped about, "I carry 45 ACP!" or "USP Tactical" or "Glocks only, because they're relieable". What's issued and whats used are two different stories. As I understand it, if you use something different than whats issued, you gotta provide the parts, maintanence and ammo, not to mention carrying the thing. Training and bullet placement are paramount, not what handgun is used. Besides, a handgun is a secondary weapon NOT a primary. Most SpecOp units have commanders that give a lot of lee-way to their people because they trust them and the knowledge they have is a lot more than the average grunt. Self determination, motivation and initiative is what separates those guys from others.
SEAL's have had a large amount published in the last 10 years. If some publisher went up to you and offered a chunk of change to publish your memoirs or take a quote, what would you do? Also the amount of SEAL groupies and hanger-ons has also increased (see Kevin Dockery). It's a cycle, pretty soon we'll start seeing more books on PJ's, than Rangers, than .....