Go North to Ras Mohamed, i consider it the best spot for underwater photography in the Red sea, perfect clear water, a huge amount of different marine life....i recommend Ras Mohamed but i also agree that you dont have to miss Marsa Alam down south.
for more underwater photography sites in the Red sea go to
Red sea dive sites guide and choose the best that can fit your needs and equipments.
Have fun ..