Just my personal experience - I wasn't particularly impressed by Fiji or Palau. Raja Ampat is still on my list. But given that the OP specifically mentions macro, the only place I'd really recommend above PNG would be Lembeh in Indonesia. While I would recommend Lembeh over PNG for macro, it's only marginally cheaper. The benefit of going to PNG over Lembeh in my opinion is the non-diving cultural stuff.