Ribbon particles are currently used to simulate things like hoses and chains. It gets close to the intended effect, except that the particle segments move visibly and continuously from the source to the destination. So it looks weird.
Path 1: Beef up the ribbon particle system with a flag that generates the links once.
This behavior would recompute the ribbon particle whenever the source or destination moves, laying out each segment once. Instead of the particles flowing, they would be fixed. Hookah hoses, chains, cables, etc. would look like they do now, except without the uncanny flowing motion.
For the particle effects, there is no server behavior other than storing the additional flag(s) for the particle system. No impact on physics.
Path 2: True support for cable physics, e.g., "tetherball physics".
This is like what Valve introduced 20+ years ago in the Source engine and made a big deal about in the Half-Life 2+ games, so no, this is not a brave new idea that couldn't possibly work in SL. It is VERY old-hat.
This does have simulator impacts because the cables would be expected to drape over objects, etc., and presumably it should be possible to have physical interactions with them. They would need a setting that would control how bendy the end joints can get. Texture pinching and stretching from going around corners would be the developer's problem. Flexibility per unit of length would have to be specified, as would articulation to any moving surface (and by this I mean specifically resistance to deflection at the joint - not asking LL to support arbitrarily complex articulations - just one): if I make a tire swing with this, how easily should the tire pivot? A tire swing probablay doesn't need to allow much deflection because it has a large mass, so maybe just a ltitle. A hookah hose wouldn't allow any deflection at all; it's glued into the mouthpiece. On the other end of the spectrum, a string tied to a knot inside a tin can would be very bendy at the joint.
Unsure of IK impacts: if you make a tensegrity table (four strings pulling the edges of two platforms together while one string pulls them apart, keeping them in constant tension - look it up), does Havok walk the chain and make the thing stand up under tension? I think that might already be an automatic consequence of doing this, not sure. LL would certainly not be the first implementer of this kind of object under Havok.
Use cases for this are everything there is now (hookah hoses, chains, and so on), plus certain things like industrial robots, swings, tetherballs, etc. Basically anything where cables have to bridge between two objects, either of which could be fixed or moving) would get WAY more realistic.