I guess when you say 'best' - best at what?
Removing dead spots everywhere?
Removing detritus?
Growing coral?
Exercising fish?
Oxygenating the water?
Suspending food?
Growing plankton?
My priority is coral growth and detritus removal. For that, I think a strong uniform flow in one direction for the complete tank cross-section is needed, followed a few seconds later with the same in the opposite direction. The period is similar to what you'd experience on the beach (12 sec ?). This is like a full tank gyre or rotating current. All the water moves together.
That should be interrupted every once in a while with other elements like surges, surface waves, standing waves, alternating flow returns, etc...
In my next tank, I'm going to create new rockwork (again) with PVC cores (again). But this time, I'll hook up the PVC cores to a flow system so the holes in the rocks deliver a pulsed flow of water out of the rockwork.