I´ve done 5 liveaboards in the red sea, something like 100+ dives.
I am not a "fish person" but...during my trips there I´ve dived with dolphins, hammerheads and napoleons. While none of that is "macro", those dives will stay with me forever.
Like others have said, there are pyjama nudi´s...