It's been several years since I rode through to check it out. I remember thinking... Where are the trees? Looked like the campers are packed in pretty tight! Road noise from Hwy 150 wouldn't be fun. Don't recall the rates back then during the off-season. But, it wasn't my cup of tea, anyway.
For me, I prefer
Ebenezer Park, a 26 acre York County, S.C. park, just over the NC/SC state line in Rock Hill, SC. Not as much "glitz". Much bigger sites, FHUs, free WiFi that works throughout most of the park. Open lake views and woodsy sites available. The bath house is reasonably clean during the season and very much so during the off-season. Neighborhood is super. The park sits between some expensive homes. No road noise other than around the public boat ramp. First come, first served with 69 sites. There are maybe 3 or 4 sites that I wouldn't be happy with. The price is in the range of $28/night.
Unless you have a specific need to be in Sherrills Ford, you can use Google Earth to view a portion of both parks. IIRC, the address of Ebenezer is around the 4400-4500 Blk of Boatshore Rd. Rock Hill, S.C.