Even though it is off of Little Cayman, you can reach it from Cayman Brac also (the islands are 7 miles apart). The boat ride is about 45 minutes or so. This dive is often rated as one of the top dives of the Caribbean and it is easy to see why.
One of the sides of the wall is called Donna's Delight. It is a sheer wall and you can easily look down into the abyss.
Some other option is to check some parts of the wall first ant then up to the shallow reef portion. Lots of fish on this dive along with thousands of garden eels. Really neat formations too.
Deepest depth 94 feet and visibility about 100 feet.