The viscosity of liquids decreases as temperature increases. The viscosity of a lubricant is closely related to its ability to reduce friction. Generally, the least viscous lubricant which still forces the two moving surfaces apart is desired. If the lubricant is too viscous, it will require a large amount of energy to move (as in honey); if it is too thin, the surfaces will come in contact and friction will increase.
I use 5-30 in my car cause that's what the manufacturer recommends as was the car I had before that. The 90 weight oil I used for my manual trannies was 90-120. Differentials use the same. Its thicker than molassas.
You asked me to use standard motor grade oil in my car. I do ,as does billions of other drivers. Why then , don't you try some 90 weight in your car and see how it runs. All auto parts places sell 90 weight.
I've used Amsoil Synth oils for 20 years. They were originally developed for EXTREME high temps in jet engines. I think what you read about 100 weight is the oil a jet might use, But , for me, I'll stick with what the manufacturer recommends, and I have a feeling he (and everyone else) knows more than you.
I have not seen anything searching the internet for anything close to SAE 100 oil. Perhaps you can post the link you got this info for as I'd like to read what is said about it.
Meanwhile, this sheds light on oil viscosities and the 1st paragraph talks about what high viscosities do. The second number is the viscosity at 100 degrees centigrade and I don't see my cars oil pump trying to PUSH syrup thru to my valves and crank bearings.