Well, most of the loads discussed have made their bones in the hands of police officers around the country. They tend to go for loads that conform to the F.B.I. standard for velocity and penetration of both soft targets and hard targets. Lighter loads are generally faster and more likely to exhibit reliable bullet expansion in most situations and usually don't overpenetrate to a great degree because of it. If they can be had in bullet shapes that function well in service weapons and calibers that are handled well by the average officer so much the better. To that end, handgun development and ammunition development tend to travel parallel paths.
As for wheelguns, rumors of their demise are greatly exaggerated.
You and I will likely not live to see the day they are relegated to museum pieces rather than hard working guns suitable for the streets or the game fields.
At the risk of committing felony thread drift, the only thing further I will say on the subject is that the .38 Super is a fine cartridge with a long history of performing well in the hands of skilled shooters and if nothing will do but to have one, go for it. I did and was glad to have the experience but in the end, the difference to the target on the receiving end between similar loads in the .38 Super, the .357 SIG, the 9mm Parabellum and the .357 magnum is going to be largely academic.