I cant remember to have seen it, but it would be a nightmare to implement. First, you have two tides a day. Second, the time shifts by 6 hours a week. If you have low tide at 10 you will have low tide at 16 a week later and also at 22:25 the same day. And third, how high the tide gets is dependent on what coast. Mediterranian sea has about 10cm, but venice about 100cm. If you have walls or rocks you can see the algae and guess how high it will get. Someplace like New York has about 2m. And then there are places like Los Angeles, where you do not have a sinus curve, but a bigger alternating with a smaller one.
Compare
https://www.tideking.com/United-States/New-York/New-York-City/
https://www.tideking.com/United-States/California/Los-Angeles-County/
https://www.tideking.com/Italy/Veneto/Provincia-di-Venezia/Venice/
My guess is, that most games do not even correctly place the sun in the sky, let alone the moon. Or, gasp, show correctly the phenomenon if you can see both in the sky.
But yeah, i imagine some secret places or clue games could use that as a plot device. But those seldom take real time into account. If you can specifically wait till low tide, it is so suspicous that players will know what to do. And if you play over several days, if you have accurate tide implemented, the sea level would allow for you secret to show on a different day at the same tiem.