Well since I seem to be one of the few (or maybe only) people on the board that camps at Camper Village every year, I will respond. You should enjoy your stay at Camper Village. It is really cool to be camped right next to all of the actions and surrounded by roller coaster mountains. If you want your campsite to be quiet, then try to get a spot as close to the lake as possible.
When the main portion of Camper Village used to be larger, you could literally camp right next to the pull out of Magnum's first hill. We were camped right around there the first year that Magnum opened and it made for one noisy evening (although I personally didn't mind.) Now, Soak City is in that area, so you are not quite as apt to get a noisy camping spot, but closest to the water is definately the most peaceful area.
-------------
...and enjoy the rest of your day at Cedar Point, The Am-aaaa-zement park!