Lake Resia: Quite an eerie sight – The 14th century spire (presumably once the heart of the village) and its surrounding village were flooded in the 1950s for HEP. In winter the lake freezes and can reach the spire by foot.
And another one from Ranten, Austria:
Also reminds me of Miyajima Gate in Japan, which can only be reached when the tide is out. But I don’t think The Hole is big enough to become tidal. Potentially The Rig could become a bridge across, but I think the ending needs to be more disruptive than that.