Nereas, it is very apparent that you wish to be as safe as possible while enjoying the sport of scuba diving. From your posts, it also seems apparent that you wish to limit your diving to recreational diving.
That is fine, there is absolutely nothing wrong with diving to enjoy the spendor of a reef, beautifully colored fish, wrecks or just the feeling of weightlessness as you glide through the water.
Frankly, I enjoyed the reefs and sights of my recreational dives of the places I have been blessed enough to visit. I can understand how someone could be totally satisfied if his/her diving was limited to strictly that type of diving. But dont be fooled into thinking that is risk free. Dont think you have no chance of DCS or any of the other calamities that can happen to a scuba diving, including death.
Like you, I wish to be safe. As NWGrateful Bob put it in one of his posts, I want to make as many ascents as I make descents. I have chosen to take as much training as I can from the best instructors I can find. I want to learn about technical diving, cavern and cave diving and beyond. My yen to learn is not because I wish to swim 15,000 feet into a cave at 180 feet in depth but because I know if I have the knowledge and training to do those dives safely, I will be a better diver, safer for me and my teammates.
I am terrified of getting trapped in a cave with not enough gas to exit safely but I know that that fear can be overcome with knowledge and training.
Do not limit what you do by what you fear. Fear is ignorance. Ignorant of how to safely overcome that which scares you.
Good luck to you. I hope that one day you decide to venture beyond your comfort zone and take training that will open new avenues of wonder for you to enjoy.