I happened to be at the range this summer when a safety violation occured. Although not directly involved in the incident I was talking with the individuals when it occured (the actual offender was an accompanied guest). I believe it was the safety director that also witnessed the event, he was wearing a bright orange safety vest at the time. The SO approached the group of us and handled the situation very professionally and correctly. Before leaving the SO was filling out paperwork and I overheard that the incident was meant to be later reviewed/addressed at the next board meeting in accordance with club guidelines. Obviously this incident should not have happened in the first place, but since it did, I have to say it was a positive experience regarding the way it was dealt with.
Not a member yet but was just looking at the website yesterday as a possible place to join. In all the clubs i've belonged to in the past these types of official SO programs always seem to be the downfall of the club or at least in enjoying it. It's not so much the concept of a safety program but usually due to the selection bias of those that are drawn to volunteering for this position.
Often times those drawn to this position are very authoritarian, older and cranky, and tend to be just strictly target shooters with no interest in firearms as self-defense tools, and don't understand when people try to train at the range for this type of use. This is where you get rules like no drawing from the holster, no rapid fire, etc. etc. until you can't do anything at the range except train to be a bullseye shooter. In reality if an incident is going to happen it is usually going to happen quickly and be out of the control of the RO to begin with as posted above. The RO can reinforce good safety habits if he sees violations but accidents usually happen too quickly to intervene. Usually as another poster mentioned they often just end up hovering around watching you like you're an idiot. It sounds like in this instance you may have an okay team of RO's with just a couple bad apples.