Yup, used to go there growing up. Saw the Obama's there while they where in office. I never noticed anything sinister, just beaches and riding bikes.
Reading those pizza related emails, and seeing how many rich Hollywood types have connections there definitely paints it in a different light.
Chappaquiddick is also where Ted Kennedy dropped a girl and a car to the bottom of a pond.