Howdy,
I don't think there is one type of water movement for reefs, simply because there are so many different types of reefs.
I believe Delbeek and Sprung cover water movement over the different reef types in Vol 1 of the Reef Aquarium.
I don't think you can have too much water movement in a tank. I do believe that the water movement in a tank can be too forceful.
For example, say you want to move 500 gph in a 55. You can use 2 maxijet 1200s and get close to that. Unfortunately the force of those 2 powerheads would be very strong in 2 distinct directions. Most likely, all the corals in the output flow would be "blown away".
Now, you could use 5 maxijet 400s and get 500gph overall. With the 5 powerheads, you have more points of origin of the water movement, plus you don't have the blasting effect that 2 1200s would have.
I have 8 MJ 400s in my 80g, all running off of a Wavemaster pro. I use Y-cable splitters to run 2 pumps off of each "channel" on the wavemaker. I have pumps that are on the same "channel" facing different directions so there is always varying water motions.
Check out Reef Aquariums to get an idea of specific water motions, although it will probably be difficult to duplicate them exactly in a tank.
Good luck,
Scott.