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.