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.
Link