Some last minute stuff came up and we tried to make our flight last night but we missed it because they closed bag checking at 45 minutes before the flight takes off.
My heart sank for you hearing that, but I guess it turned out ok, and we might be able to see you at the Reef. Not sure what studios we (four of us - two couples, my wife is a non-diver) will have, but I'll send you a private message with my cell#.
Make sure you book your dives with Ocean Frontiers soon, because we booked three or four weeks ago, and all thier AM dives were filled up for 6/5-12, so we booked three days of PM dives (which we wanted anyhow - hate waking up early to rush around on our vaca). The only disadvantage with PM dives is that surf may be rougher than in the morning.
Maybe we could all go do the Lighthouse point shore dives together too. We are not as newbie divers as you, but essentially are the same - we like to be cautious, and our experience will help you alot. I wouldn't worry too much about the 100 foot dives - they likely say 100 foot in the ads to generate excitement, but they don't force anyone to go to 100 feet. You really don't want to anyway cuz it will cut your dive time down (unless you bounce to it for photo op like me, and then come up slowly).
If you plan to get their on Friday, try to get a shore dive in the same day you arrive or next saturday for sure, so you can get used to your equipment and have a real good confidence building AND EXCITING! experience. All the shore dive ops have guides that you can pay to give you the tour and boost your first-timer confidence. We might try to do a shore dive at Eden Rock or Sunset House before we even get to The Reef resort after we pick up our rental car, so we don't have to drive all the way back to the West side on our first day. Then our plan is to rent some tanks from OF and do AM shore dives before the PM boat dives at OF on Sunday.
Make sure that you check out this website here on shore diving spots on GC:
Grand Cayman Islands Scuba Diving, the Cayman Islands offshore scuba diving guide,Shore Diving,Grand Cayman dive site locations
You will see that Anchor Point is quite close to The Reef, as well as some south sites in case the weather is rough on the north side.
I'm excited for you on your first real diving trip, and you will likely cry underwater like I did.