If I had a loose $300 and that's in nice condition, it would have a new home, fast. Esp. if it's stainless.
I don't own any SIGs, but my son and his wife have several, inc. a P-239 with a Hogue grip. They tend to be top heavy unless a loaded mag is in place, but some feel very good in the hand.
Like the Walther PP series, it has a fixed barrel and should be quite accurate. Snake head accurate, at reasonable ranges...
If one accepts .380 power, this is probably a sound gun. I bet it fits inside a waistband well, and the P-232 is supposed to be more reliable than the P-230, esp. with JHP ammo. I think I recall that they have a raised cant to the underside of the slide, like the Polish P-64. This probably helps to avoid slide bite on fleshy hands, a problem with the Walther equivalent.
If you get it, let us know how it works and how it shoots. It will be easier to shoot well than your snub Colt .38 and won't develop cylinder timing problems, for sure.

But the .38 can use some ammo that will outclass anything sane to put in a .380.
You could sort of split the difference by carryng a Pistolet Makarova or Polish P-64 in 9mm Makarov.
But the ammo may be a little hard to find at times, and I'm not sure if foreign ammo is non-corrosive.
Short of the Beretta .380's, the P-232 may be the most reliable .380. German police studies of the 7.65mm Model PP found an average of one jam in 50 rounds. I don't find that acceptable, so prefer small .38 revolvers.