I like the Super and currently own two 1911s in this caliber (1 Colt and 1 RIA). The problem with the Super is that factory ammo (at least the "mainstream" ammo) is so underpowered that if restricted to those loads you may as well have a 9mm.
The Super is the same physical size as the older 38 ACP and full-power Super loads are dangerous in these old guns. For safety, the ammo makers now load the Super to the same power level as the 38 ACP. No lawsuits, but also no "Super" loads, either.
The 38 ACP was loaded to around 1050 FPS. The Super pushed a 130 grain bullet to 1300 FPS.For many decades all Super ammo was loaded in nickel cases while 38 ACP was in brass so shooters could tell at a glance which they had and wouldn't load the Supers into an old gun by mistake. I guess that wasn't enough for the lawyers because I noticed a few years ago that the Super ammo was coming in brass cases. I clocked some factory ammo and sure enough, 1050 just like the old 38 ACP. Technically, there is no more 38 Super from the major ammo makers, it's all 38 ACP.
Perhaps the specialty ammo companies offer true Super loads but if they do I am unaware of it.
I load my own Super loads and this cartridge can be loaded to impressive levels. My favorite load uses a 115 JHP at a measured 1450 FPS. This is getting into power levels associated with the 357 Magnum. My guns seem fine with this. I have gone faster, pushing 1600 with this bullet but I got pressure signs at that point and backed off. I think the 1450 load will do the job and seems OK in my guns.
Unless you load your own, or can find somebody like Cor-Bon making full-power ammo, the Super will not live up to its full potential. With proper loads I think it's extremely effective, leaving the 9mm in the dust and rivaling factory 357 Magnum power.