Normandy is nice, but I have only been there in November. Indoor pools, two outdoor pools, looks like a lot to do when they are fully open.
Bayview is nice. THey are slightly overprotective with the pools - kids need coast guard certified PFD's, no swimmies.
On the other side of the bridge is Bourne Scenic park. They have two new pools and you want to be on that side of the park. We will be there for a week in June. They have the pools, playground and a canal bike path for biking, walking, jogging. There are always boats or all sizes going through and a couple years ago we saw two pilot whales about 30 feet away from fisherman.
Had: 2007 ST31QB
Have: 2008 Winnebago Sightseer 35J
2006 GMC Yukon Denali