You really want something with anti-foaming qualities, as the oil is being forced through small holes while doing it's damping action thing.
This leaves you with two good options, IMO. Either Auto trans fluid (ATF), which incidentally has additives to help keep the seals vital. Or, fork oil, which has everything you need fork oil to do.
Personally, I think the damping action is a bit wimpy with the standard 7-ish weight viscosity of ATF. So, I use fork oil in 10 Wt (some prefer the 15W. But, I find that slightly on the harsh damping action for my tastes).
The oil weight kinda depends on the lbs weight you are putting on the bike and how much you want the tires to conform to washboard roads while leaned over. If you are riding over a lot of pot holes, you'll want the thicker weight oil, too, in order to reduce suspension travel bottoming on the front end.
It's a matter of taste and what goals you have, which you did not state.
Cheers,