It's been discussed earlier and some turbulence is normal, but if you start with turbulence, you end up with a chaotic flow.
When I snorkel or scuba on the reefs, I experience a pretty consistent bulk flow that is a wall of water moving in the same direction. It's not little jets of flow from PVC outlets or pump heads. The two flows are very different.
As far as alternating, it's is necessary IMO. There is never an extended flow in one direction on a real reef. It's always alternating. Nature operates in an alternating flow.
You don't inhale continuously from one direction and exhale in another... You inhale and then exhale. This is why you don't see sediment buildup like in a captive glass box. It's also why detritus doesn't settle.
It's a constantly dynamic but smooth experience.
This is my attempt at replicating nature. I came back from two weeks of daily reef snorkeling in Cancun and the flow in my reef just felt artificial. I already have a tremendous amount of alternating and surge flow... My tank is 8' x 3' and a double surge event raises my water level by 3" with four 2" PVC siphons actively pulling it into my massive double sumps!
It's just not the same...