For a while now I've benefitted from the excellent advice dispensed on this site, so I figured it's about time I contributed after spending last week in Grand Cayman. Every summer my wife and I spend a week at the Plantation Village Beach Resort, where we own a timeshare. We honeymooned in Grand Cayman several years ago and have been returning ever since.
Plantation Village is located on the far south end of Seven Mile Beach, a few properties south of the Marriott. As others on this site have noted, Plantation Village is not overly luxurious, but it is a fantastic value, provides all of the amenities which are important to us and is in a great location. We go to Grand Cayman for the beach, the snorkeling, the food, and to spend a week where the most important decision each day is where to eat dinner that night. Plantation Village is perfect for us but is not the place to go if you want 5-star luxury.
The size of the beach at Plantation Village varies from year to year due to the resort's location, which makes it susceptible to erosion. Some years there is not much of a beach, but we have never found this to be a problem because one needs only to walk a short distance up the beach, where there is plenty of beach. However, this year the beach at Plantation Village was the best that I've ever seen. There was plenty of sand. The water in front of Plantation Village consists mostly of coral reefs, which makes for excellent snorkeling.
Activities: I can't report on many of Grand Cayman's activities because we spend the vast majority of our time on the beach. We typically go for a jog on the beach in the morning, eat breakfast and lunch in the condo, and spend the rest of the day on the beach reading, snorkeling, and just hanging out. This year we did go for a drive around the entire east end of the island, which was very scenic, and went snorkeling at Eden Rock, which was beautiful. In the past we've done Rum Point (great place to sit, relax and do nothing), Sting Ray City (a lot of fun, definitely worth doing); Hell (not worth doing); and the turtle farm (worth doing once). We avoided the dolphin swim for reasons which have been amply covered on this site. Watching captive dolphins perform tricks in a small tank is not our idea of a good time.
Food: As I said, we usually buy groceries and eat breakfast and lunch in the condo. For dinner this year we ate at the following: Aqua Beach Bar (We were disappointed with the food here, although our expectations were not very high. We have found Coconut Joe's to be a better choice for a casual meal.); Casanova (Good Italian food, great atmosphere and service with an outdoor patio on Georgetown harbor); My Bar/Sunset House (Another casual restaurant/bar, which we enjoyed. Great waterfront atmosphere.); Calypso Grill (One of our favorites. We enjoyed it the most this year. The sticky toffee pudding may be the best dessert I've ever had.); Ristorante Papagallo (Consistently good restaurant with excellent service.); and Cracked Conch (This was our first time there, and the food was very good, but we were disappointed in the limited menu. Excellent waterfront atmosphere.) We also ate lunch at a local roadside fish fry/jerk chicken stand near Bodden Town, which was excellent, but right now I can't remember its name. In the past we've also enjoyed The Reef Grill, Lobster Pot, and Grand Old House. We also like Gino's Pizaa for a casual meal in the condo. We've always been disappointed in the service and the food at The Wharf.
As is often stated on this site, food in Grand Cayman is expensive. Our bill for two at a nice restaurant is usually in the neighborhood of $120 U.S., including drinks and an appetizer or dessert, and a 15% gratuity is included at most places.
Alcohol: For beer drinkers such as myself, there really seems to be no alternative to paying relatively outrageous prices. A case (24 beers) of Miller Lite (which is as cheap or cheaper than any other beers that I saw) costs over $40 U.S. For me this is just part of the price of the vacation. Liquor, especially rum, seems to be more reasonable (for instance, a fifth of Tortuga rum is about $13 U.S.).
Car Rental: We always rent a car and cannot imagine doing it any other way. We enjoy seeing the island and trying new restaurants. The past few years we've used Andy's and had no problems, but this year we got a cheaper rate from Dollar ($250 U.S. total, including tax, for a Toyota Corolla for the whole week), and found that Dollar's cars are newer and thus a little nicer than Andy's. With Andy's sometimes the air conditioning was not very effective.
Weather: The weather in July is usually in the upper 80's or 90's. This is not a problem for us, since it is about the same here in Mississippi. The weather is almost always perfect; there are the occasional showers, but rarely does it rain for more than an hour or two. July is also a great time to travel because there are no crowds (except in Georgetown when the cruise ships are in), and hurricanes usually aren't a concern until August or September.
I'm sure there are other aspects which I've overlooked. Hope this is helpful.