I have not been to Andros, but I have been to Grand Bahama and Nassau since 2020, and the quality diving is poor. There is a lot of dead coral, so you will be disappointed in what's left of a so-called reef. Many things have contributed to the conditions, and this is based on what I've seen personally and heard from the locals. Hurricane Dorian in 2019 ripped through the Bahamas (but maybe not Andros) and the affected islands are still recovering. Lots of the population left the islands and went to Florida, leaving a shortage of workers. The fish population is virtually gone because during COVID the locals fished out the sea. The government of the Bahamas has banned spearing lionfish and the population is out of control. I've seen the biggest lionfish in my experience in Exuma Cays at only 50 feet. They have no fear of harm and will swim very close, and there's so many, I had to kick them away with my fins.