Well, I liked Blue Hole but I know a lot of people didn’t. Here’s my experience and you can decide for yourself whether you want to go...
It’s about a bumpy 2-hour drive offshore, then you get to the Blue Hole, you drop in and descend into the abyss. Thankfully, the dive master was ahead of us or I would have been nervous about seeing nothing but dark water beneath me. There’s a nice cavern with stalactites at about 140 ft that you swim through and then, you go back up. One of the dive masters and I brought up the rear and we were escorted out by about a dozen large reef sharks who were more inquisitive than threatning. Since we were so deep, we had to do a longer safety stop. In summary, I really liked it - it’s my deepest dive to date and I enjoyed the rock formations and the effects of the light on them. If you enjoy caves (wet or dry), it may appeal to you. If you dive mostly because you like reefs and pretty fish, this is not your idea of fun.
If you decide to go, Amigos del Mar makes an all day trip out of it and they make you a great lunch on an uninhabited island with web-footed boobie nesting grounds. Then, you do a couple of shallower dives on pretty reefs and head back in.