Much of the 38's bad reputation was earned using 158 grain, standard velocity, round nose lead ammunition. Citing examples of people shot with a .38 and who eventually died does not have any relevance to the argument as the reason for shooting someone is to achieve immediate incapacitation. Advances in bullet design and propellents have done much to make all handgun ammo much more effective than it was as little as 20 years ago.
While 2" guns are wonderful for concealed carry, the homeowner is better off with a 3" or 4" barrel as they benefit from higher velocity and can be fired more accurately by marginally trained individuals.