i ve been often in the Red Sea,
and i ve enjoyed both,
wide angle and macro.
The problem there is simply that not many guides know what is there in the water....
You can get nice shrimp, pygmies and a lot of other stuff,
but most time not guided, only if you find it by yourself.
Most of the guides are europeans who wanna make money and dive, or egypts, who are not really trained for it.
If you visit like me some places for years, you will find out, that the guides even dont know their house reef...And after a change, i
was not interested going there again, because i am not willing to have to take a guide with me, who is not knowing what i know, and is limiting me....
I have been to a hotel with a great housereef, and in a two week trip, did half of the dives there, because it had everything.
Including turtles, eaglerays, white tips, and lots of macro stuff.
But after a change in the dive center, it was not possible to go there and enjoy it and get pictures...
PS: was using the 70 - 180mm Nikon Macro zoom lens ;-))