The Luminous Lagoon at Glistening Waters near Falmouth is really cool. I've been there several times. A couple tips to maximize the experience. Try to go on a night with little or no moon if possible and don't go out too early. The darker the night the more impressive the sight.
