Kona
I do not think of the Kona as a true destination for diving. But it is a great multi-purpose family vacation spot with many things to do.
By far and away the best diving is the manta night dive. It is very good for divers and for snorkelers. The diving is about 30 feet deep and you all sit down in a circle around the projector which brings in plankton which brings int he mantas. The arrival rate is very high. We had one female show up and she was a show animal. She swooped and danced for as long as we had air in our tanks. At one point she swooped over my daughter and looked like she was going to crash right into her but then belly rolled on top of her instead. My wife, who does not dive, saw the whole show from right overhead. I have talked with others who have been there recently and they have seen up to 30 mantas on a night. For divers and snorkelers, this is just fantastic.
The diving topography is kind of boring, even compared to the Caribbean. Because of the remoteness of the islands, they do not get many eggs to setup shop. But we did see a lot of interesting animals. We saw lots of eels and several of them were quite interesting and unusual. We saw a half dozen turtles in 4 days of diving. We saw a leaffish, a frogfish at about 100 feet, and several interesting snail like creatures. I was surprised to see just how many things we saw in a few days.
The water is very clear-- up to about 100 feet of visibility in places. It was probably in the 75 to 78 degree range which is not real warm if you are diving more than a few dives a day.
We dove with one of the local dive operators and they were great. My two teens both got their advanced PADI certs while here. They were very comfortable with young and inexperienced divers. This is a great place to get certified. The only negative is that the logistics are a bit painful. You have to drive a harbor where you meet the boat and then have a 20 to 45 minute boat ride to the dive sites. The dive masters were great with my children and I was pretty much left by myself to snap photos and find little fishes.
We stayed in a two bedroom condo on the edge of town which was right on the water. We even were able to do a couple of shore dives which were pretty boring. We made steaks and fish on the grill most nights which we bought at the local Costco. It was every bit as good as a restaurant for about 1/3 the price.
Of course, there are so many things to see and do on the big island of Hawaii. My kids went parasailing which was a highlight. We had a luau at a local resort. We drove around the island to see the volcano on the other side. This is a full day adventure and you are best to leave at around 6am so you have plenty of time to stop and do things. I have not been diving anywhere else in the islands, but I believe that this is one of the best spots on the islands.