I used to use brake fluid, but that was not kind to the paint if it managed to leak out.
OH! Really? Are you sure that you don't mean Automatic Transmission Fluid (ATF)?
I have a '74 450 MKIII, with Marzocchi 35mm forks that is used on public roads, the majority being small backroads with potholes, ripples and manholes etc. The ambient temperature when I am out riding the bike is in the range from 5°C to 25°C, the majority in the range 10°C - 20°C. If your ambient temperatures when riding your motorcycle are higher than mine, you may need to use an oil with a thicker viscosity.
I have found that Castrol ATF suits my riding style and roads fine. Using a 10W fork oil produces a pneumatic drill/pattering effect from the forks. Not enough to cause problems on the road, but sufficient to be noticeable.
Enlarging the damper holes (be careful) increases the flow rate of the damping fluid and hence may make for a more plush ride than standard,
IF the same damping fluid is used.
Fork oils manufactured by differing manufacturers using the same "weight" label e.g. 10W, have differing viscosities (Resistance of a fluid (liquid or gas) to a change in shape, or movement of neighbouring portions relative to one another. Viscosity denotes opposition to flow. The reciprocal (opposite) of the viscosity is called the fluidity, a measure of the ease of flow. Molasses, for example, has a greater viscosity than water.
Britannica_definitionThe manufacturers of fork oils/damping fluids use of the oils "weight" e.g. 10W is meaningless. Differing manufacturer's fluids labelled as 10W have differing viscosities, so you are not comparing like with like, but an unripe lemon with a ripe banana!

I would suggest a study of the linked table, the manufacturer's owners manual and consideration of your combined weight, with that of your machine and the ambient temperatures that you ride in.
Dynojet_Co_Table_of_fork oil_viscosity_by_manufacturerMake sure that everything is spotless when re-assembling your forks, I use brake cleaner to clean all the internals before assembling and no rags to "give it a wipe", workshop paper towels if you must wipe it.
I hope this helps you make a choice.
Good health, Bill