I'm reminded of that time last year when I made a last minute trip to Cedar Point over Memorial Day weekend, and the only hotel in the area that wasn't $500 a night was the Maples Motel....about 5 miles down US 6 east of the park, and the only thing separating the hotel from the double-line freight tracks was US 6, and the hotel was right near an intersection that crossed the tracks. Literally every 30 minutes a train would roll past and blare the horns. The proprietor, who was admitted awesome, was gracious enough to offer ear plugs on check in.
The campground is a great option, as long as you plan on cooking your own food. Again, the only food options in Doswell are KD, Burger King, 7-11, and gas station fried chicken. Ashland is 1 exit south and has plenty of food options.