Keep in mind of the lakes posted, Harwell will have more rooms but most are on 6&20 creek, Hurricane ramp is next to most of the motels but it is a pretty good run to big water from there.
Keowee all hotels are in Seneca and require trailering South Cove would be the ramp of choice.
Clark Hill would be the State Park as usual.
Murray still trying to find a place near the water besides the motels on I 26 in Newberry.
Or you can post your choice but I'm not going south of Columbia.