One of my favorite handguns for many years has been the Colt Single Action Army revolver. I have one of each (1st, 2nd, 3rd generations and a Bisley Model) produced between 1885 and 1979, in calibers .32-20, .45 Colt, .357 magnum, and .44 Special. I have used these enough to consider myself reasonably competent and I would not feel unarmed with any one of them.
That said, the SA revolvers would not be my first choice for self defense or discreet concealed carry. They are rather bulky and a bit heavy. Aside from range use I am limited to 5 rounds for safety's sake. Reloading is slow and would be very difficult under stress. There was a very good reason why many old time lawmen and bad guys carried two, three, or more revolvers when expecting trouble.
As a holster maker I do receive a few orders for concealment holsters for the SA revolvers. To put that into perspective, the last time I tallied up a year's orders the numbers came out at 62% DA revolvers, 37% semi-autos, and 1% SA revolvers. Now that represents only one holster maker, and others would probably report different numbers, but with 13 holster designs offered for 162 different handguns I think it illustrates things fairly well.
There is a "cool" factor that just can't be denied, though. Show up at the range or a nice barbecue with the old hog leg strapped on and you have the attention of everyone there.