What are some campgrounds with on-site theme parks?

We're big fans of Holiday World Amusement Park in Santa Claus, IN. Lake Rudolph Campground is a huge campground that is right next to the park, and has all the amenities you need, including non-stop shuttle service fom the campground to the park.

Small water park at Yogi on the River in Gardiner, NY. It's a really large rv park, nice setting in the Catskills. Would highly recommend this park.

The Jellystone Parks usually have activities for the kids. Waterpark type attractions and hayrides if nothing else.

Six Flags, Darien Lake NY. Walk to park from campground. We have been there numerous times when the kids were little. Very convenient.
https://darienlake.com/

Moose Hillock Fort Ann/NY Lake George
Moose Hillock Warren NH, White Mts
Bull Run Regional Park Centreville VA


These 3 don't have "theme parks" but I would consider similar or better than Frontier Town, IMO

Bayley's Camping resort ME Scarborough
Normandy Farms Foxboro MA
Watkins Glen/Corning KOA, NY

Mike

Dutch wonderland in Lancaster Pennsylvania

Cedar Point Amusement Park near Sandusky, Ohio.

And there are a couple campgrounds right at Indiana Beach near Monticello, IN.

Lake Rudolph campground next to Holiday World in Santa Claus, Indiana.

Lake Compounce, as was mentioned already.

There are at least one or two campgrounds in Lake George that offer shuttle service to the Great Escape.

Many Six Flags parks (that I'm aware of) do not have associated campgrounds, and I don't think many if any Great Wolf lodges do either; in fact, I think the latter usually require that you stay in the associated hotel to use the water park. I may be mistaken, though.

I know you mentioned it, but I personally think it's hard to be Knoebels.

Carowinds Amusement Park

Located off I 77 at the N. Carolina/S. Carolina border

Has their own campground