I've had occasion to fire .357 magnum revolvers, both indoors and outdoors, in law enforcement encounters back in the 70's and 80's. Not pleasant at all, massive disruption of all the senses. It is more than the noise, there is a massive difference in muzzle blast, muzzle flash, and recoil that make it very difficult to focus on the situation at hand, much less address the need for a follow-up shot, time to seek cover, etc.
I've also used .45ACP for clearing huts, bunkers, and tunnels in Vietnam. Again, nothing pleasant about being inside an enclosed space with a serious handgun being fired, even when you are the person doing the firing. Not pleasant at all, very disorienting to say the least.
I'll use .357 magnum loads for hunting, when necessary. For personal defense, home defense, or other routine uses I will stick to .38 Special +P ammunition, thanks all the same. My J-frames will be loaded with standard velocity loads, not +P's.
The current trends for small-frame .357's, ultralight .357's, etc, all seem to be little more than marketing ploys for the unitiated and unenlightened.
YMMV, I'm sure.