Light on the water
You do not need a dramatic sunset to find something worth looking at.
On a cloudy day, the water borrows its colour from everything around it. A pale sky, a dark wall, a row of autumn trees. The reflections are recognisable for a moment, then a boat passes and stretches them into loose vertical lines.
It is an ordinary scene, which is partly the attraction. The buildings stay still. The canal does the moving. A small change in the surface is enough to make the same view feel different.
A little less sky
One way to look again is to change the frame. Leave out most of the sky and follow the water instead. Notice where a window becomes a bright rectangle in the reflection, or where the shadow of a bridge makes the canal seem deeper.
Some views work better as a short pause than as a destination. A minute on the bank, the sound of an engine receding, and then back to the street.
A note for grey days: soft light is still light.