Hi,
@Dezbian nice to meet you this is my first time giving my opinion on a thread so here goes. I was in a similar situation a few years ago whilst trying to find the so-called best and in the process wasted a lot of money which I can only take as bought/gained knowledge. So I am sure you know there are three types of flow these are gyre flow(maxspect and others), constant flow(basic powerhead), and pulsing flow(controllable flow via app or box). You first always look at your tank size and choose the right size of wavemaker that won't firstly look ugly and secondly won't have to fish flying out of your tank due to it creating tsunamis. I think you need around 25x the return rate of the total tank volume to keep the water moving and prevent it from getting stale, without water aggregation your fish will die and so will your corals. If you have a high demanding SPS tank only you can have a more powerful flow as SPS like that and it helps them receive nutrients and remove waste now if you have the same flow for SPS as you do with LPS or softies you will see them closed or open possibly with very little to non-polyp extension. Ideally in any situation want at least one pump pointing towards the surface to create surface agitation and at the same time have it mid to low height so that all the detritus can be free flowing in the water collum this way it can find its way to your mechanical filtration. The 2nd 3rd 4th or however many may suit your tank are there to fill in where there are dead spots to try to keep all food fish poop suspended so again it can find your filtration. I have also included a basic picture of how I would tackle flow in a tank I hope this helps have a great day/lovely evening.
Marine Lunatic out :)