Going to the red sea I had a similar experience with the guide ending up going inside a wreck with a group where many just had the continuation course after open water, through no out-of-gas situation.

It is a common discussion topic I hear among divers, and almost everyone who been diving for a while has had a similar experience. Dive guides get basically all of their income from tip, and it creates a strong incentive for them to bring guests into areas which the guest might not be qualified to be in. Same for instructors at popular resorts.

To me the whole experience was a major incentive to get better training and gear so that next time I won't be under qualified to do the dive, and the more training and equipment I get the more I realize how dangerous diving can be and how little redundancy recreational diving have. The basic premise for open water dive is that you should be able to rocket to the surface at any point, and that there is a second diver next to you at all time. Being the last person inside a wreck is neither of that.

But I will end this comment by saying that one should not let guides ruin ones enjoyment of diving. There is a lot of great diving to be done within the limits of recreational diving.