I much prefer a revolver over an auto. Perhaps the main reason is I reload.
I can not think of a single use I have for a pistol/revolver that a 40 would be as good as a 357.
But then some people need a lot more shots to hit something and for those people maybe a 40 would be better.
If for some reason it turned out you couldn't hit anything with your 357 but you wanted to carry a gun, they would recommend a semi-auto pistol, like maybe a 40 S&W, that had a full magazine. Hope is the bad guy will run into one of the bullets in the air.