I've used ATF for decades. ATF is one of the most advanced lubricants on Earth. More research has gone into ATF than into motor oil. In order to do what it does in a transmission it has to be very highly engineered. It's very low viscosity enables it to get everywhere on the internals of a ratchet. It flat out works.
Perhaps the best lubricant would be John Deere Corn Head Grease as it's very thin NLGI 00 and thixotropic meaning that it changes viscosity with shear. I've used this in my angle grinders and polishers for many years and it works far better than any normal grease as typically all normal grease does is fling onto the perimeter of the gear case without ever seeing the actual gears ever again. You can literally hear how much quieter angle grinders are using Corn Head Grease compared to the stuff that they ship them with from the factory.
Somewhere there is a spot on the internet called something like “grease journal.com”. There are likely people there anxious to share their extensive research on greases and lubricants and want desperately to challenge your sense of ”the best lubricant”, which they regard as grease blasphemy.
Point is, oils and greases are really complicated. ATF is amazing for what it was designed for. Mobil 1 is pretty amazing and modern. Superlube was designed for food industry machinery. There is no ”best” in lubrication.
Thinsotropic and thixotropic sound made up, but are real terms (I use daily) and only mean “having a thin (or thick) form or shape”. Substances that change viscosity with shear are typically called “pseudoplastic“, but all greases have shear strengths that can be exceeded leading to a break down of the greases‘ lubricating properties, if that’s what you meant.
We’ve probably discussed this before. I went thru a personal quest to consolidate my stock of greases. I looked at 4 ball test data, temperatures etc. Mobil 1 is pretty amazing and I’ve switched to that for all NLGI2 uses.
For ratchets, it’s tough to beat the properties and convenience of NLGI 1 Super Lube. I wouldn’t dare mention it on greasejournal.com, but I suspect any decent NLGI 1 lithium grease would do just as well (Example: Mobil EP-1 ) The key is to use it correctly. Never pack the gear teeth with grease.