nice place for boating, i used to live 10 minutes away on the paradise side(lime saddle marina)and use it often... personally i would launch out of bidwell marina on the oroville side(opposite side of lake)and travel under the green bridge, I.M.O. that branch is the nicest on the lake(not that the lime saddle side isnt nice).... i believe that bidwell marina has campgrounds too(i know for a fact that lime saddle has a brand spankin new campground with full hookups, but you have to drive to get to the marina). if i'm not mistaken there are also floating barges that you can rent too (like a houseboat, but permanently anchored)... of course for the ultimate you should rent a houseboat...
try these links: bidwell marina oroville lime saddle marina