Night fishing

I’ve tried wading at night 5-10 times. Out of those trips I’ve only had luck a handful of times and it was a grind. In the past I’ve always waded areas I know would be productive during the day, and I normally tried fishing them at night hoping for bigger fish. It’s just never panned out. I’m curious what conditions guides and successful night fisherman look for. I could probably boil my question down to this, would you rather night fish on a full moon, clear sky, low to moderate wind? Or on a new moon, cloudy sky, 10+mph wind?