We go to 6 Flags NE every year now. It's not WDW, but it's the only other theme park I'll spend money to go to. DH and I found out about it back in 2001 and have been back every year since. We buy the season passes for the NE park and then use them both there and in NJ (we only go to NJ once a year though because it's too crowded). Season passes were about $60 this year and I'm sure we'll get there 5-6 times, so it's worth it for us.
The bes tthings about 6Flags NE are: 1. Less crowded than other 6Flags parks I've been to; 2. It's a smaller park (less walking); 3. More shade and seating available!; and 4. I saved the best for last.. the water park is attached to the main park and there's no extra admission.
We usually get to the park around opening time, go on the big rides in the morning, hit the water park around 11 am and spend the hot part of the day there, and then go back to riding stuff when it cools down.
Like other people mentioned, it's really not near Cape Cod though. Hotels in the area are pretty reasonable. There's a Best Western nearby that's my hotel of choice (you get free breakfast in the hotel restaurant and they have a great indoor pool) that we can usually get for $89-$99 a night.
I'd be hesitant to call Agawam "the middle of nowhere." There are actually a few minor attractions in the area, like the basketball hall of fame, a Titanic museum, etc. It's also a very nice place to go berry picking or pumpkin picking. I've been to the middle of nowhere, and it's not in Central Massachusetts.

Plus, I have relatives who live in the Agawam/Feeding Hills area.