I feel like I've been waiting my whole life for this question. Apophis is such an underused myth, honestly. It's not just a snake, it's the embodiment of utter chaos, the thing that tries to swallow the sun every night. Most modern fantasy touches on Egyptian mythology in a shallow way—pharaohs, cats, maybe a sphinx. But finding something that really digs into Apophis's specific vibe of eternal, cyclical destruction? That's rare.
For a direct, awesome take, you absolutely have to check out 'The Kane Chronicles' by Rick Riordan. Yeah, it's middle grade, but Riordan gets it. Apophis is the big bad across the trilogy, this force of primordial chaos trying to break the Ma'at—the cosmic order. The way he writes it, Apophis isn't just a monster to fight; he's this pervasive, corrupting influence. Every bad thing that happens, every ripple of chaos, ties back to him trying to escape his prison. It’s accessible but surprisingly faithful to the myth's core concept.
For a much darker, adult-oriented twist, I'd point to the 'American Gods' extended universe, though it's more of a cameo. In the 'Anansi Boys' novel, there's this background idea of old gods fading, and the crocodile god mentions Apophis slumbering in the Nile, which I always thought was a chilling image. Neil Gaiman excels at that sense of ancient, indifferent power. You don't get a full narrative, but the implication that Apophis is just... there, a piece of the world's forgotten machinery, is somehow more terrifying than a front-and-center villain. It makes you think about chaos as a permanent, dormant fixture of reality, not an event.