Just speaking for current divers (as I’m too young to have experience with the old divers):
Yes, there are crazy ones. But diving itself is quite safe. As long as you follow the rules. Even diving deep hast safety layers. As long as you follow the rules (!!!).
The most important rules: plan your dive, equip yourself according the plan and the most important rule: follow your plan and don’t change it mid-dive.