Is it only the divers staying at the far South resorts who get to go to Delila or Palancar Gardens for night dives?
No, our house is in town and we always meet the boat at the Caleta. Paradise is right outside the Caleta entrance, but that's not where we always go. Boats picking up divers at far south resorts in all likelihood started out at the Caleta anyway. Talk to your operator. To make a long boat ride economically feasible will require a certain number of divers, especially as it's usually just going to be a single dive at night. Those divers need to be willing to spend whatever time on the boat is needed to get to and from the site in the dark, and potentially get a bit chilled on the way back.
Anyplace other than paradise.
There's nothing wrong with Paradise unless several other boats are there. One time we gained a member of our group (which had previously consisted of just our DM, my wife, my son, and I) when a bazillion divers from someplace dropped on us. We headed out into the sand to hunt for stuff and avoid getting kicked, and this guy just stayed with us. After MANY attempts, my wife finally convinced him he was with the wrong group.
We've found all sorts of cool stuff at Paradise at night, including seahorses. Some of my best night dives have been there. We sometimes dive privately with our instructor friend who rents a boat from his buddy. We can go literally wherever we want. When Sandro recommends Paradise, that's where we go - he knows his stuff and he's never steered us wrong.
Santa Rosa as a night dive was 'interesting' to say the least.
A long time ago, on my son's first-ever night dive when he was 10, we ended up trying to dive there. He had trouble clearing his ears so descended slowly and because of the current he and I got separated from the rest of the group. My wife tried to stay where she could see both our lights and those of the rest of the group. Then my (rented) primary light died. Then my (personal) backup light died. Then my son's light started to go wonky. At that point my wife's light disappeared. My kid and I hovered over the bottom as it zoomed past and decided that although we had decent visibility due to the full moon and his iffy light, we should thumb the dive. Around that time, the boat returned with the rest of the group after my wife had made them come get us. Everyone decided the current was excessive for a night dive and we ended up having such a good time on Paradise that my son has been a night dive addict ever since. He still usually tries to keep his light off or covered as much as possible.