I've done well on moonlit nights around Stage Inlet where I could see the dark profiles of fish against the sand. Best fly patterns were (a) black velvet eel fished on the sand tied with strands of flash coming out from behind the eyes (b) black slim jim style flies fished on top mostly schoolies, silver stripe and eyes mattered and (c) black bigeye baitfish tied with reflective cheeks, big eyes and olive pearl flashabou. All Page Rogers patterns when I was in my "Page Rogers rules" phase. All were very effective on moonlit nights on Nantucket Sound shorelines in spring and fall especially at slack high from Stage to Herring River to Bass River and sometimes Parker River. Since our cottage is a short drive from these spots I would tend to hit these most. There were some non-descript spots where at high tide the fish would sit and rest and letting a black velvet eel sink into these holes would result in sure takes. One used to be just to the west of the mouth of the Herring River off the west jetty, it's filled in since. Along the shoreline if you know where the larger striations in the sand lead to shore and come together into a basin the fish will run these on the incoming on any night, moonlit or otherwise. I scout these during the day and fished them at night.
There was a night on Herring River that a large group of squeteague set up in the dropping tide currrent eating small bait, they would not take anything I put in their face but before I left I hit them with the big magnum flashlight and saw that they were weaks. It was a very moonlit night.
Another night at Bass River the cops shut the gate after a megaphone annoucement so I slept in the truck and the bass were keeping me awake busting in the flat just to the south of Stage Island's east channel. I was sated from a night of fantastic fishing so pulled the sleeping bag over my head and tried to ignore them while I slept. Bass River on the outgoing at the end of either jetty with large bigeye baitfish patterns has produced for me as well during latter half of September and October.
Since becoming completely addicted to sight fishing I haven't fished at night for years, but I would assume much of these observations haven't changed.
I am on a quest to land a very large bass on the new beach rods to test their limits and if I must I will go nocturnal, but I hope I can do it in daylight.
Good luck Greg.