Sarah,
My roommate in college was from the Cape, and I spent three summers there with her family. They live in Wellfleet, which is one of the best towns IMHO. As you go further down the cape, things do tend to get a little bit quieter, but there's still lots of action in the summer...