I found that during basic cave training, the lights-out stuff was some of the more relaxing drills. It's just you, the slow hiss from your regulator as you plod through the skills and get through it. I didn't see what the big deal was.
Fast forward about a month to my first non-training trip. We had done a few dives and I feeling confident (I should have known this was a bad sign). We ran a line into the catacombs behind another team (having not been there, I did not know it is a 1-team passage). About 100ft into it we were slowly surrounded by a wall of silt. Vis went to zero in no time flat. I was running the reel at the time but I couldn't turn around so I had to move forward, feeling the width of the tunnel w/ my fins as I loaded my kicks until I could turn. As soon as I did, I waited for my team get into place we got turned around. Then we exited just like we did in class; touch contact, slow, smooth, and steady.
At first, I just thought "oh ***!", this is the real deal! Then I thought, "Great, the deco stop is going to have a field day with a group of intro divers dying in the catacombs, 100ft from the entrance in 50ft of water". But then things started to come together. I had full doubles, in shallow water, and I had tons of time. My team was intact, everyone was calm (I could hear everyone's regs breathing slowly). So we just lined up single file and followed our training. The only thing that really worried me was that there were two lines in there so there was a risk of entanglement. If there was an entanglement and we had to cut lines, we could have left another team in there w/o a continuous guideline if we couldn't repair it in no vis. Thankfully, we all stayed off the floor and made our exit w/o issue. Once we got out we talked about it on the surface, chalked it up to a learning experience, and went back down the eye.
So I definitely came away with a different appreciation for my training. I also paid much closer attention to the details of my surroundings during my apprentice/full class having been in a real situation and learning what information is useful when the time comes. I also take a lot more mental notes during the dive, keeping track of gas usage during ingress/egress, marking time to jumps, etc. so I have more information to mark my progress in a no viz situation. But most importantly, I take more care in keeping myself out of those situations in the first place.