I have dived the Red Sea from Eilat to Djibouti, and from 1982 to 2006.
It is not true to say the further south you go the better it gets. It depends very much on when and where you go.
The Straits of Gubal area has plenty of wrecks. The deep water offshore reefs (The Brother Islands, Elphinstone, Daedelus, Elba, Angarosh, Shab Rumi, Sanganeb, Darat Abid, Zubair, Qoin Rock, and the Seven Brothers) have the best chance of encounters with pelagic life.
The inshore reefs in Southern Egypt have very dramatic hard coral formations but are surrounded by relatively shallow water so few big fishes. The last time I went to Daedelus (the most remote reef in Egyptian waters) I counted 120 divers on it! The last time I went to Jackson reef (Straits of Tiran) I had close encounters with two longimanus. The best whale shark pics I ever took were off the beach at Eilat!
So there is no way of knowing which place will give you the best dive on a particular day! Enjoy what there is when you are there.