Sure :-)
Objectively speaking, the most dangerous moment I've ever had scuba diving was in a straight-sided sinkhole, with no overhead environment at all, doing a refresher course, for the first (most basic) level of cave diving, after a few years off! Some unexpected things went wrong, and I suddenly realized that I was seperated from the group, 40 meters deep, silted out, tangled up, and the scary part: hyperventilating like crazy, and absolutely about to panic. It took every ounce of 35 years of diving experience to keep it together, which I only just managed to do. It was amazing how quickly it went from totally cool, to totally about to panic - it felt like only seconds. It taught me that I'd got MUCH TOO COMPLACENT, and needed to refocus things. This was quite a few years ago, and I felt the effects for several years afterwards.
A later expeience was when I went through a small restriction that I and my buddy had been through several times before. For some reason, my buddy couldn't get through this time, so I turned back - and couldn't get out! Try as I would, it just wasn't happening. I'd go in, get stuck, back out, check my gas, close my eyes, wait for my heartrate to go back down, then try again. After maybe 10 minutes trying, I eventually managed to wiggle out. Now I wear my tanks "side mounted", so I can unclip one or both of them to reduce my profile.
A few months ago, a buddy and I were diving with another pair. We were in front, they were behind. Then they disappeared, so after waiting a while, we turned back to see what had happened. I then found that the tunnel we were going back through, was completely silted out (perhaps 6 inches visibility), and the fixed line seemed to disappear under a rock, into the ground! I couldn't find where it came back out. In our part of the world, you're hung drawn and quartered if you touch the cave - anywhere - at all; but stuff that, I heaved that big sucker off the line, which happily sprang back into place, so we continued into the murk!
The last two examples might seem a bit scary, but those kinds of situations are just part of the learning process in cave diving - every competent cave diver is equipped and trained to handle such things. The first example, mundane as it may sound, was the one that really scared me.
Shall I book you a place on the next course? :-)
[edit: spelling]