Most fun had with a pistol was probably using my S+W 586 for IPAS. Actually having a reason and purpose for the multishot pistols makes them so much more fun, and shooting socially is a gas - much banter was had.
The Webley Alecto a close 2nd for back garden shooting just for how quiet and accurate it is. Accurate guns are always more fun.