We stayed at On The Bay for 3 weeks in March. We were on the island for a wedding along with 30 or so family and friends and we were the only ones who chose not to stay on Seven Mile Beach and were so pleased we did. This place is idyllic - paradise.
The condo itself is spectacular - clean, tastefully furnished and so much space - we were a party of 5 adults and had everything we needed and more. All the time we were there we practically had the beach and the pool to ourselves. And the view from the balcony is to die for!
Mark (the owner) and Mitzy ( property manager) were attentive but not intrusive and there was plenty of info in the condo for local restaurants/ places to go etc,
You do need a car to get about - its about 15/20 mins drive to Rum Point , about 25 mins drive to the nearest large supermarket and about 45 mins to Georgetown and Seven mile Beach .
If we ever get the opportunity to return to Grand Cayman we would definitely stay here again .