Brewster, MA is just short of the "elbow" of the cape, in the area called the mid cape. Camping here put us in the middle of the cape with both ends not far away.
Likes: the campsites were seperated both by elevation

and brush as well as split rail fences.

Each has a stone fire ring

instead of those iron ones many places have. Water and electric were on the site within easy reach. Each site is level packed sand and is well drained.

There were plenty of bathrooms each was clean and mostly well kept after. Each bathroom has a playground nearby, and a large set tub type sink outside for dish washing. There is Wifi but it got busy fast, best to use early in the morning. there's a beach for boating and fishing at the campground on a small pond, good for a short paddle. No swimming allowed. (MA requires full time lifeguard on all public pools or beaches)
Just across the road from the campground is the Cape Cod Rail Trail, a paved, many mile, bikeway, there are benches along it and even a "traffic circle" where three main branches come together. The trail cuts along ponds and cranberry bogs, if you didn't bring a bike, many places will rent them, the views are well worth it! (we did find the trail info dated, a dinner ride became much longer than expected as the eating place we were headed to was now a proffesional bldg.)
While the campground is a short drive from the beach, it is too far to walk, and even by bike it would take a bit to get there. Beach parking or any boat ramp in the area is $15/day, the beach is free after 3 pm. parking passes are for sale at the town offices.
Dislikes: other than the distance from the beach, we didn't have a problem. While the camper sites were private enough, the tent sites seemed very much on top of each other, and thanks to the terrain, most tent sites were hard to even get a vehicle up to, trying to park a tear on them would be almost impossible. Most tent sites had water, but not right on the site.
The rec hall was nice, with a "library" of books and movies, a big screen TV. The money wasting electronic games are in the basement and can't be heard upstairs. There is a campstore that says it has everything you could need, and minigolf on site. They sell firewood there, but we found we could get more for less outside the campground. During tourist season (why can't you shoot any if they are in season?) the campground has plenty of activities, canoe racing, bands, pancake breakfasts and tractor pulled wagon rides each saturday night. There is also a farm next door owned by the same family, and horseback riding offered as well.
The cape is really an Island, the cape cod canal cuts it off from the main land.

It isa sea level canal with a paved service road along each side, perfect for walking, bike riding, or inline skating, there is one company that gives a boat tour through the canal as well as jazz cruises and diner cruises. (we brought our own lunch for an earlier trip). The Canal is worth the time to see it. There is also an RV park (not really a campground IMO) under the Sagamore (southern) bridge. My family stayed there when I was a young teen, the sites are more like a parking lot with pull through spaces seperated by a row of trees.

The one big attraction to staying there is that the park fronts on the Cape Cod Canal land side service road, almost any time of day you see people fishing or just boat watching in the canal.

If you bring a boat, Buzzards bay at the south end of the canal is a great place to explore or swim, (only motorized boats are allowed in the canal, the tide turns every 6 hours making traffic interesting).
Nantucket sound is on the southern side of the cape, it has shallower beaches and plenty of sea life, the water here is warmed by the gulf stream.
the outer side of the cape (east) is also warm water, facing the on ocean it has the biggest waves, great surfing, and steepest beaches, the beaches here are a known of as the Cape Cod National Seashore, they are much more wild and open, unlike the rest of the cape. Most of the beaches have a huge drop from the level of the Cape dunes to the beach. Parking is not free for most beaches, but you can shuttle or bike in and get in free that way.
Cape cod bay is the part inside the cape, it has cold water from the north pole and very little wave action,

at low tide the water goes out nearly a mile in some areas,

leaving the best shell collecting I've ever seen, along with plenty of tide pools to explore.

Provincetown is at the very tip of the cape, the Pilgrim monument

is a great way to get the picture of how narrow and long the cape is, on a clear day you can see Boston from it. The town is an interesting place, like most old new england port towns it has narrow sometimes winding streets with plenty of tourist traps, artsy shops, and and any type of food you could want. The former Methodist church, now the town library has a 2/3 scale schooner built right down the middle (worth the visit if you like ships)

there are a series of pictures in one stairwell showing the construction. the whole town faces the harbor, our parking lot had a boat ramp so we went for a paddle and ate our luches afloat. Parking in town would be a challenge with a trailer,(and cost more) find a place outside town and ride in on a bike, most of the locals get around that way.
The town is a LGBT dominated place, most aren't that in your face, but with plenty of guys in drag etc. and crazier stuff the further toward the tip of the cape you go in town. (not a place I would take young children).
There is a long pier in the harbor

with plenty of boats offering rides, fishing, whale watching and charters. (We took a sailing trip on a Schooner)

(bay lady II) You can also catch the ferry to Boston from here. Race point, the very tip, has a few light houses, a visitor center, bike trails, the air port, and camping. With a 4 wheel drive you can go out to the very end on the huge beach.
We were only there 5 days, while we saw some of the cape, there is plenty more to see and much more to do. The lower cape is more of a suburb of Boston and has the traffic and sprawl to match, head to the Mid and upper cape to see the real cape.
there are also plenty of great light houses along the cape, my current picture is of the Chattham light,

(the point of the elbow) where my great aunt served in the coast guard during WWII. This was the only all woman station, anywhere, they maintained the light, trucks, generators, a Shoran station (her job), heated with coal, and practiced boat drills, shooting and running on the beach each day as U boats were seen near there often. There are tours there, but only a few hours one day a week, in season.
gallery/album.php?album_id=3183