Anilao is one of my favorite spots for macro shooting. Wide angle opportunities are great as well but most people associate Anilao with excellent macro life.
There is a good mix of diving. It is not all muck diving, in fact, far from it. Many of the reefs are lush and beautiful, for example Twin Rocks and Beatrice.
I have stayed at both Acacia and Crystal Blue. Both are good and you would not go wrong with either. Acacia is slightly higher end and the prices will reflect this. The property is beautiful and the acacia tree in the middle of the garden is spectacular.
Dive sites are all within a few minutes by bangka. Traveling end to end of the straight in a bangka would probably take 25 minutes, so I wouldn't worry too much about having a house reef. Average boat rides will probably be in the 10 min range.
How much you enjoy the diving will very much depend on your guide. I have used Edgar at Crytal Blue before and he is fantastic, highly recommended.
In Bohol, I have dove Cabilao. The diving is pretty good but not as good as Anilao - the reefs are healthy and there is a lot of macro life, just less of everything compared to Anilao. If I rated Anilao a 10, I would rate Cabilao a 7. I have not dove elsewhere around Bohol.
Neither place has anything close to a party scene.