I'm staying in Boston in the summer and want to visit marthas vineyard and cape cod.?

Is it better to stay at those places? Where is exciting for a 12 year old and 8 year old who are easily pleased?