There is much more to see going south from Camp Holly than there is going north. There is the old union cypress railroad line, Indian mound, Spade Island, the edge of the Jane Green swamp . . .going north you have to go quite a ways before you get to anything interesting.
Of those hotels listed above I would NOT recommend the York Inn - it has a bad reputation and gets visited frequently by the police. I've not heard anything bad about the others.
Camp Holly has some hookups for RVs, but you should definitely call ahead to verify they have what you need.