I think I should give some flavor as to what this would be like as it seems not many folks have done this at night.
We were on the Zion with Jim Abernethy's shop. This was a dedicated photo expedition to try catch the actual act of spawning. There were four buddy teams. The original dive plan was to place a mooring buoy and descend/ascend on the line. However, the current was so strong that the group expressed a preference for a hot drop drifting into the wreck, and a drifting safety stop/pickup at the end. Everything went fine and all divers hit the wreck first time (if they missed they could be picked up for a second attempt). Navigating betweent the various wrecks was a challenge with the current, which was too fast to swim against. Maribi and I had to "crawl" on the sand between the Zion and the Jenny (we spent some time at each), and no one could get to the Bonaire tand back to the Zion except two dive teams with very large scooters. Maribi and I decided it was too risky to try for the Bonaire with current because if we missed the Bonaire by even a little our dive would be over and we would have to surface. It was a struggle to use and move around with camera gear in the current over the sandy bottom (where a lot of Goliaths were), but in the wrecks it was fine. Another team staked out protected positions behind the Zion for the duration of the dive. The dive went without incident for everyone (although no one got the shot--but almost!), and the drifting safety stop and pickup also went fine. That being said, it was a challenging dive "on the edge" even for some of the highly experienced divers. As you can see every team had its own strategies (and specialized gear) for handling the dive. I think Dan Volker has a write-up on SFDJ about this dive or a similar one. It captures the sheer intensity of the experience.
I offer this description to give a flavor for what this will be like. It is intense and demands full concentration all the time.
We did enjoy flat calm conditions and excellent vis. The main stress/risk factor was the current and diving at midnight. This is the type of dive where people need to be ready to call it off if conditions are not optimal and settle for a reef dive instead. For best vis high tide is best, but that is also when current might be highest.