I have played the Player's Club and Foxfire courses numerous times. The Foxfire is great for drinking and having fun, but honestly not a lot there. My favorite holes on Foxfire are the back to back par 5s, 16 and 17. The Player's Club has some holes that encourage you to think. Brett, holes 14, 15 and 16 are like playing in a bowling alley, though I personally enjoy them. There a couple great short par 4s as well that entice you to have a go, holes 3 and 6. 3 of the 4 par 3 holes are over water and are not the best part of that course. I like all the par 4s and find Player's to be a solid course overall.
As far as top in the area, I would go with Granville and Longaberger. Indian Springs is a nice option and one I grew up playing, but lack of maintenance over the last few years has hurt it. They recently did a ton of tree removal, some of it, not necessary and frankly may have detracted some strategy from holes 3 and 5 as there were great old Cottonwoods that required you to execute a shot to one side of the fairway in order to have the best angle of attack though the trees were large enough you could still shape a shot around them. A solid layout overall and worth the trip if in the area. I grew up on Woodland Golf Club about 45 minutes from Columbus near Indian Springs and it is a Jack Kidwell Design. I would put in the sporty category with a few nice holes, but nothing worth making a trip on its own. Not a long course, but some fun holes.
As to Winding Hollow, I think the layout is nice enough, but seemed like every time I have played there (about 10 times) the course was really wet and overwatered. Despite all those times having played there, no hole really stands out as all that memorable to me. Whereas Granville and Longaberger, most of those holes are easily recalled.
I think Columbus has a lot of good courses for the public, but some travel is required for what I feel are great courses. The good news is that travel is an hour or less.