We always did well mooring in Trellis Bay and off of Marina Cay.
X2. Recommend Trellis over Marina, as the Scrub island shuttle runs just off the mooring field and sends a wake through the field until 10 or so at night (at least it did the last time I was there in 2019].