How about the actual tide charts from one place that has loads of SPS.
https://tidesandcurrents.noaa.gov/noaatidepredictions.html?id=1612301&legacy=1
Flow does change; it's strong (and in the forereef with the heavy sps coverage, often to the point where it's not that fun to swim). And when the tides change it changes direction. When you go down past a certain depth, say 60 feet or so, the tidal effect can be much less, and flow can be even linear. It depends on the ocean geography of the area.
That being said, in nature the amount of flow and light an average coral colony gets, even in the tropics, can vary due to weather (to include days without lots of light). Obviously, randomly decreasing the amount of light is not good for your corals.
For my part, I always use tidal swell mode on my MP40s, and vary the intensity a bit day to day, and turn it down 2-3 notched at night ( unless I decide that there should be a storm either day or night

). I run NTM daily, and have sometimes forgotten to turn it off for several hours.
ETA: on the forereef, in addition to tidal flow there’s a lot of random flow, at least at the first 15 feet or so of deptg. Also, it’s very clear that you can grow coral very successfully with a constant amount of random flow in an aquarium.
And yes, the amount of flow and waves is generally less at night that it is during the day. At least at the surface, due to a number of weather related factors, I believe.