What are peoples opinions on the best weighting placement for photographers doing macro work?
The best weight placement for macro work is the placement that works for you. Figure out where to put weights so that you can stay horizontal, face down, without moving, and use as little weight as possible.
Many people need to add ankle weights because their legs and fins are too buoyant. I suffer from heavy feet, and use an ankle weight around the top of my tank to make it easier to stay horizontal. Distributing weights top to bottom is important, and you need the correct distribution for your body type-- there is no one-size-fits-all approach.
Another issue is distributing weights around your back and front. If you get this wrong, you can end up doing accidental half barrel-rolls. My torso is more buoyant than my BC-tank-integrated weights, so my natural position is lying face up in the water (heavy tank and weighted BC are down, beer belly is up). Although you can get some nice Snell's circle pictures from this position, there's not a lot of macro to focus on. I distribute weight in my BC to the front pockets so that I can either be face up or face down, with a very slight tendency towards face down. Distributing weights front to back is important, and you need the correct distribution for your body type-- there is no one-size-fits-all approach.
Basically, my advice is to move your weights top to bottom and front to back in the way that works for you. Most people need more weight low and behind them. I have an unusual body type, and I need more weight high up and in front of me. Do what works for you, not what other people do. Back plates are great for some people, but not helpful for others.
Although this might seem complicated at first, once you get it right, you won't need to alter your weighting scheme again. Suddenly all diving will be easier, and hovering motionless for macro pictures will be effortless.