Both ATF and fork oil have the stuff to keep the seals from drying out.
Both have additives to keep foaming at bay.
So, it is a matter of how fast the fluid can flow through the internal valving. Thick oil makes the damping action slower to respond.
ATF averages about 7 wt for viscosity. For my 550's I like 10Wt. For the 750s I like 15wt.
You'll feel the road bumps more in the bars with heavier wt oil, and it will take the tire longer to regain full contact with the road on rebound. Some prefer the solid feel heavy weight oil provides. Of course, too light an oil will allow the tire to oscillate (bounce) during rebound from bump.
FYI, if you mix 10 Wt oil with 15 Wt oil 50/50, you get 12.5 wt oil.
If you feel the need for fine tuning.
If you routinely ride where the forks bottom
AND top out in their travel, you probably need a thicker oil. If it mostly bottoms, or mostly tops out, then you need a spring change (weight or rate).
Cheers,