I worked at COI for several years (96-98) and had a blast. The MB programs and offerings were pretty decent when I was there (I moved to VA in 2000.)
The campsites at COI vary greatly. Windy Hill is probably the nicest campsite, but is very remote, and is a long hike to the mess hall and activities (5-10 minutes.) Oconee Camp is pretty big, and has an adult lounge/adirondack (3 sided cabin.) It is the closest camp to the Meadow, firing range (hope you don't mind waking up to shot gun blasts) and the general program/MB area.
The Greenville "A's" is a mix between Oconee and Windy H