Lake Compounce in Bristol, CT -- about 45 minutes away. It's claim to fame is its the oldest amusement park in the country. It's actually very nice and almost the whole park has been updated. Had season passes last year......so numerous times.
Also, Six Flags New England in Agawam, MA. It's OK, but gets too crowded in the water park (yucky!).