cayman and turks would work well..
in cayman's stay in the tourist area (seven mile...or maybe rum point) and you drive to the kite spots
a small but super friendly group of locals. fwiw, is a good chatting them up before going out (as you should do anywhere...but the best foiling spot i saw needs local guidance)
if confident on foil its pretty cool to kite all
the way across north sound then take a pit stop @ stingray city..
i know some folks worry turks will become overcrowded like cabarete if 'everyone' knew about it... but turks is an upmarket place and as not close to being overdeveloped by hotels (flights are generally cheap...but lodging&food are not)
the family would love staying on grace bay beach...which you quickly understand why many consider it the single best beach on the planet.
kiting is done @ long beach.. the water is shallow.. so you'll need to watch the tides (or stay south where water is a bit deeper)
influenced by same burmuda highs as cabarete...but goes 24 hrs (unlike cabarete)
as far as pretty water goes.. turks may be as good as it gets.