Thanks for the reply. We actually got it working in an unexpected way.
More info: our host only has a single dual-NIC adapter. The production traffic for guests and our iSCSI is on the same LAN. I had set one for iSCSI and one for guest networking on this same subnet. Each NIC was connected to a single switch.
After the reboot I checked again. I added the NAS NIC addresses back into Dynamic Discovery and noticed that the Static tab showed all LUNs as before. It appeared that the reboot didn't solve the problem. I did some digging into other possible steps. I followed these three articles. Those ruled more things out but didn't fix them still. I then realized that I didn't have to separate the NICs. I put the iSCSI NIC back into our guest VM switch. Then I kept digging and noticed that there was an error message when scanning:
Login to iSCSI target iqn.2000-01.com.synology:dcpcsbhqx-n0001.target-1.asigradata on vmhba35 @ vmk1 failed. The iSCSI initiator could not
establish a network connection to the target.
Login to iSCSI target iqn.2000-01.com.synology:dcpcsbhqx-n0001.target-1.archive on vmhba35 @ vmk0 failed. The iSCSI initiator could not establish a
network connection to the target.
At some point after this I noticed that all of a sudden our LUN showed up. It was available and I was able to add it as a datastore, format as VMFS and put it into production. I'm still curious why it didn't work with the single NIC. Also curious why I saw several instances of above errors and then it just mounted. But glad it's working now.