It could definitely cause issues if it forced a story to stop and made the player wait until low tide to progress. I think it could be cool to hide treasure in open world games though.
