These are some videos I show my students:
The Eaton locker requires a speed difference to lock-up. They were (are?) used especially in GM vehicles. Most manufacturers, if they offer limited slip, use clutch packs on the side gears. Auburn gear traditionally used cone style limited slip, which when worn cannot be rebuilt. They do last a long time though. A third type of LSD )limited slip differential) is a Torsen or worm drive style. Originally used in the USA on military Hummers, I believe. There is also a manufacturer in the United Kingdom named Quaife of the worm style.
A modern vehicle with full time 4wd has three differentials, one in each axle and one in the transfer case. With this system you can actually have only one tire spin even in 4wd. A part time 4wd (off-road only) either locks the center diff or doesn't have one at all. They call it part time since it should not be used in high traction conditions (highway driving), only in off-road or loose terrain.
Lockers are best, but they have to be able to unlock for turning so modern vehicles often use electricity applied lockers or something like the Eaton. There are also some cable (Ox) and air (ARB) actuated lockers.
I have Lock-Right (Powertrax) lockers in a Jeep Cherokee, they unlock when off the throttle, and it is very capable. In low traction conditions all four tires spin. Even when trying to climb a solid granite "hill" all four tires would spin because I didn't have enough traction to overcome gravity and mass.
I would really like to put a locker in my '23 Tundra, but I haven't located an aftermarket option yet. One day.
Just my two cents.