The dash to live by the water, one of the most defining property market trends of the pandemic era, has finally subsided.