I have a .357 magnum.
It is reliable and has great stopping power. The noise alone would probably cause the perp a change of underwear.
On the con side,,,,can't think of any. Unless you are not trained. I had 23 years worth of annual requalification.
Ruger SP101 is a good choice. Use round that aren't likely to penetrate the neighbors house. And a good secure storage area or lock if kids involved.