Whether or not to dive the Blue Hole is a well worn topic on this board. If you have the time, you might want to search back a couple of years for a thread that ran quite a few pages of debate.
A couple of things I would add: you can cut down on BH travel time by staying at one of the atoll resorts, Turneffe Island Resort, Blackbird Caye Resort or Turneffe Flats. All three make the BH trip once a week and it takes about an hour each way. My understanding is it takes more like two and a half hours each way from Ambergris Caye. Regardless of where you stay, it's a full day trip out and back because you'll do a couple of more dives in the area, and those dives are highly rated.
Or you could do a two-day trip starting further south with Splash Dive Center in Placencia. They dive all the "hot spots" up and back, spending the night on a nearby caye before doing the BH first thing the next morning on the return trip.
Although from the air the BH is spectacular, from a boat it's just more water. The only way you know you've arrived is when the boat captain pulls up at a buoy.
It's a "bounce" dive. You descend to the lip at about 50 feet. Once the group is assembled, then down you go to 130 feet. You hang out for about five minutes, looking at sharks if they're there and maybe swimming around one of the massive stalactites. Then up you go back to the lip. Hang out some more, looking at sharks if they're there. Safety stop next. Up and out. Enjoy a spectacular shallow lime-green water ride to the picnic tables at Half Moon Caye for an SI before more diving in the area.
A quality dive op will have a high number of dive guides to divers ratio and will watch you like a hawk to make sure you don't get into trouble. You would most likely be diving air on an AL-80.
Glad to hear Cousteau apparently didn't really dynamite his way in.
John Denver? That would have gotten old really fast, lol.
To answer your question "is [the Blue Hole] worth the money for airfare, hotel and dive boat tour?," in my humble opinion I'd say no. But diving the BH would be only a small part of a Belize dive trip, so if you take that into account then the answer is an absolute yes.