Magnum? No. For all the mentioned reasons.
.44 Special? Absolutely! One of my favorite cartridges and a well documented "man stopper". In the days before Magnum cartridges, big bore rounds such as the .44 Special and .45 Colt were extremely popular among law enforcement and for good reason too. Big slugs at moderate speeds had a tendency to end gunfights quickly and effectively.
Three of my favorite .44 Special carry guns can be seen in this picture along with their like caliber friends.
S&W 24-3 3", S&W 696 5 shot L-frame 3" and a 3" CA Bulldog. Any one makes a fine big bore CCW.