I did the BH 3 years ago, with an OW cert, 40+ salt water dives all around the Carribean. There were a few of our party non-divers that snorkeled while we were down and said it was fantastic. As for the hole, I found it to be a novelty. I did hit 140 ft, and did have a touch of narc that I realized because I was more focused on my depth, time, and air than I was in sightseeing. It doesn't take long to see some stalactites in the murk, most of which are exactly the same. I did have a 6 ft black tip come up nose to nose with me at about 100 feet, and my response to this was only "coool", so I might think I was just getting a little narced at that point already.
I classify this as a novelty dive, not a must (other than to say you did it). In all of my diving, the BH, along with Barracuda Reef in Cozumel, are the only two dives that stand out in my memory that are different because the overall feeling during the dive is "you are not just a visitor here, you are at high risk. Pay attention, be extra careful".
If I were to go out again, I would snorkel or dive the rim only. On the other hand, the other dives on the trip were extremely nice, and the lunch break at the island was a memorable experience. My opinion is that 99.99% of the cool stuff to see is above 80' anyway.

Been there, done that, the washing machine ate the T-shirt