I paddle lakes at night where the most important thing is to be seen. I have the small red and green clip on lights on the front and the white mast light on the rear. I have a yellow poly kayak so I put a half dozen or so of the harbor freight freebie work lights in the front and rear hatch. This turns my kayak into a 14ft glowing beacon, which can easily be seen from quite a distance.
If I really needed a light to see where I was going I think I would opt for a headlamp so that I could direct where the light was shining. From my experience you would miss so much by having a really bright light an thus why even go at night at all if all you can see is what is illuminated by your light.
Personally, I would not take any light on a paddle if it does not FLOAT IN WATER. If it doesn't float, it's gonna get lost in the drink. Count on it.