We have been to the Staniel Cay Yacht Club
four times now. We keep thinking we should try some other places, but just enjoy this place so much we keep coming back.
It is just what you are looking for in terms of no nightclubs, casinos, tourist traps, etc.
It is pretty pricey, but the package deal includes lodging, a boat and motor every day, three full meals a day, (they will pack you a picnic lunch if you are going to be out in your boat) use of snorkeling gear, bicycles, kayaks, and paddleboards. About the only thing not included is alcohol.
This place is all about exploring beautiful uninhabited cays by boat, snorkeling, great sunsets, beautiful beaches, crystal clear water, and meeting interesting people.
They do have a discount for pilots, and Bahamas Tourism has sponsored a fuel rebate for the past couple of years that knocks $300 or more off your bill at the Yacht Club and many other out island resorts and hotels. I don't know if they will be doing that again, but it is worth checking out.
PM me if you want to talk about the particulars of flying to Staniel Cay.
We stayed at Stella Maris Resort on Long Island on our first trip and it was great, but we think Staniel is better.