Mausers are the best pistols, high fire rate, high DPS, and holds 4 more total bullets over the Semi-Auto
As for revolvers, the fire rate differences between them all (besides Double Action) isn’t really significant, so you’d be better off just using the Navy for PvP or the Schofields or LeMats for PvE.
But if you really just want a fast revolver, then the Double Actions. They have god awful accuracy and low damage, and a relatively slow reload speed, but they do fire faster.