I saw 3 well-developed waterspouts over Lake Erie in late July of 2004, while at Cedar Point Amusement Park!
The first waterspout developed while I was on the "Meanstreak"; the train was going up the first lift hill, I looked to my left and was amazed to see a well developed rope funnel. As the train approached the top of the hill I could see a tight ball of spray at the water surface a few hundred feet under the tip of the funnel. I lost sight of the spectacle as the train descended into the first "dip", but at the top of the second hill/turn I regained visual and the waterspout had become more developed with the condensation all the way to the surface. I lost and regained view of the waterspout several times until the ride finished, but by the time I got off the coaster the waterspout had dissipated.
The other two developed about 20 minutes later at the same spot, but I was then in line for the "Gemini". A large stovepipe waterspout developed first and minutes later a thin rope developed to its east. The waterspouts lasted about 10 minutes or so and were then under cut by cold outflow from the thunderstorm, which produced them.
Didn't have a camera with me, but wish I did; I'm not going to Ceder Point again without bringing at least a disposable camera.
Simon Brewer