There is nothing particularly dangerous about it except the huge numbers of greedy dive centers who take inexperienced divers there.
To all novice divers reading this, dive within your limits and you have nothing to worry about. Do not listen to dive guides/instructors who encourage you to dive deeper than you are certified or in wrecks / caves without the proper training.
Diving is a calculated risk like most extreme "sports", and when you ignore those risks you endanger yourself and anyone else diving with you.
Don't expect your guide to care more about your life than you do.