I am undoubtedly biased, living here and have no choice but to go, but OYN/NYE is a load of fun.

If I were on a boat, I'd probably go the route of keeping the boat at Taboo or Little Harbour and cabbing over for piece of mind. Also, the moorings at Sandy Cay are day moorings you are not allowed to overnight there and wouldn't recommend that.