I've been to Ogunquit, and the water was not bad at all. Warm day as well. The key to any east facing beach like in Maine or even in MA.....a light seabreeze. That way the warmer water stays near the shore and temps are still near 80 or above.
It's definitely not totally tropical. May be some separation from the low and mid level centers. And yeah watch tomorrow aftn. Otherwise, Fay is yawn here.