My college roommate got married there last November and we stayed for the weekend. It is nice enough. I certainly wouldn't pay rack rate though. Our room was a little musty and cold, but I am sure that is because it is directly on the water.
The whole area is really nice, lots of restaurants within walking distance.