My wife and I just bought 23 acres in Dobson, NC, which has Lake Hickory, Lake Norman, High rock lake and a few small other lakes within a couple hours or less. I've been told by the local forum there that those Lakes are on the decline for size but good for numbers.
In SC, I would say look at Lake Hartwell or Lake Murray if you are looking at a fishing destination residence. We almost purchased property near those but found our dream property in NC.
Faith. Family. Fishing.
PB - 11 lbs 1 oz