I really like SeaGrape Beach on 7-mile beach on Grand Cayman. There is a great beach, a restaurant and bar and wonderful folks to take care of you. Any on the hotels are also good, but be sure you can rent the lounge chairs and other amenities.
I haven't done the submarine tout in Coz, but have heard it is well worth it.
Have a great trip!