The .38 Special is relevant to me. When I'm not carrying a 1911 I carry a revolver loaded with 158gr LSWCHP+P ammunition -- which others in the thread have mentioned as well. I normally use the Remington version but I'd like to try the Buffalo Bore offering in my guns.
A full-size revolver loaded with .38+P IMO offers a good balance of power and low recoil/flash/bang.