James Rummel has pictures and descriptions of five handguns that were very innovative designs, but turned out to be useless in real life. These include the Henrion, Dassy & Heuschen twenty-shot revolver, manufactured in France between 1921 and 1928.
http://www.hellinahandbasket.net/2009/07/5-brilliant-innovative-handgun.htm