I'm a little reluctant to chime in here, because you guys might never let me show my face in the Frugals Forum again, but I've stayed in a couple of REALLY nice places on the water in Maine. They were very expensive then, and are over-the-top expensive now, but if you really wanted to splurge:
https://innbythesea.com/
https://www.blackpointinn.com/