Heavier oil will increase the effective damping, in other words the forks will move up and down a little slower and feel stiffer.
Lighter weight oil will do the opposite, allowing the forks to move up and down faster and feel softer.
Ohlins fork oil is apparently megger expensive but is reckoned...