The .38 super was a semi-auto round that some manufacturers made firearms for. It was supposed to be the self loading answer to the .357. I don’t think anyone makes a firearm form it anymore. If you buy a .357 you can fire .38 special ammo in it to save money and use the .357 ammo for self defense.
S&W, Taurus and others make 1911’s or 1911 variants in .38 Super.
The .38 Super got something of a bad rap due to headspacing issues decades ago - it is a semi-rimmed cartridge, but some manufactures didn’t hold tolerances correctly and it would end up headspacing off the cartridge mouth, resulting in some failures to fire.
Nowadays, you find a lot of race guns (in IPSC or USPSA, for example) that are .38 Supers. They’re hot-hot-hot loads, pushing a lot of pressure to light up a compensator. Top competitors like the .38 Super because it can be loaded to make a light pill make “major” power factors in IPSC, meaning that they’re getting the same points multipliers as a .45ACP. The advantage of the .38 Super over the .45 ACP is that you can fit a more ammo into a double-stack mag with a .38 Super than a .45ACP. A competitor to the .38 Super is the 9x21mm round. My race gun mag holds 21 rounds and merely has an extended base plate.
I rarely read of someone owning a .38 Super or 9x21 for CCW use.