I had a Porsche OE slippy diff fitted when I was having the gearbox/suspension work done recently. My old diff had pretty much imploded when the gearbox failed and the incremental cost for an LSD at that point was negligible compared to everything else I was spending. My indy had also recommended I consider putting one in anyway, even before that, as he'd been subject(ed) to a few test drives with me over the years.
The following is all in my humble opinion: caveat emptor and all that.
In everyday driving I wouldn't say you'd notice any difference, unless you're testing the laws of physics regularly or sticking one wheel on the wet stuff. My C2 stuck to the road pretty well as it was, although I did regularly complain about having to wait what felt like an age to plant the pedal when cornering (certainly compared to the 944). Now I feel like I can get the power down earlier and harder - definitely more confidently on both road and track. I'm perfectly prepared to admit this could be purely psychological! Is it really useful in the course of a working week for a daily driver, though? (NOTE: that's the question my wife keeps asking. She doesn't like the answer, apparently).
All in all I'm probably neutral on it. If you're regularly driving aggressively and beyond the traction limit of the car under power (normally understeer for us 993ers), or on track and looking to shave a little time, then it's an easy decision. Other than that it's probably just a more complicated and expensive piece of kit that you won't need. I like having it, but I wouldn't rush out to upgrade a car this way again unless it needed a new diff anyway.
My best performance upgrades have been driver training, above anything else. From your list of cars (especially the 968), I suspect you might do a certain amount of high speed/track stuff, so this might be preaching to the converted. However, if you haven't done that then give it a go - you might be surprised at how good the standard car is!
Cheers/John
p.s. Reading this back through I'm not sure it helps you!