I love capturing the last bit of sun just before it dips below the horizon. This generally creates a streak of light across the frame, but also layers of reflected light on the water.
This is an abstract ICM (intentional camera movement) image of a sunset over the Mississippi River, using an in-camera, hand-held, horizontal movement to create the effect.