Fordar,
Depends on where you are flying from but I would look into Morritt's or The Reef on the East End of Grand Cayman. Young kids are easy to please and these two resorts are perfect getaways for Mom and Dad with plenty of stuff for the kids to do as well. Both are right next door to each other far away from the 'popular' resorts of seven mile beach. I own at Morritt's and know both resorts well. There are so many family oriented things to do in Grand Cayman. Look for the Butterfly Farm, Botswain's Beach, (or Turtle Farm with sharks to see, swimming lagoons, interactive exhibits, etc) Stingray City Sandbar, Rum Point, Vivians, and great hiking trails for the whole family. Also some of the best snorkeling and scuba diving in the world.
Just my 2 cents
JB