Actually ALL 3 of our ongoing D&D games currently have some prophecies currently going, which probably doesn't help (one of which I'm the DM).
While a prophecy is something of a puzzle, typically I think of it more like a vague roadmap
- sometimes they require action (is that self-fulfilling...