There are 2 ways into South Cow, if you're in a motorhome the Ukiah side would probably be better, as it's paved while Lakeport is really just a dry (right now) riverbed.
This time of year it's very dusty, but often a bit of wind is there to help out. The trails vary from a fireroad that connects Ukiah and Lakeport, down to rutted single track. There are almost no jumps, but your rock dodging skills will get a workout.
If you do happen to come in the Lakeport side and decide you don't like it there, you can travel North for about 20 minutes and be at CC camp, another good riding area.