Says more about Paizo and premade adventures than it does about the game. It existed. The problem however is that it's very hard to do something preset at that level of power. You're at a point where casters have hit peak crazy and can get up to all sorts of insane shenanigans. It's an entirely different gaming style than earlier levels. It's the point where the gm has to be a lot more flexible and adventure paths are not able to be that. Because the adventurers can just bypass or circumvent so many things.

For example. Final book of Carrion Crown. The bad guys have a base in the middle of nowhere. Certainly promising all sorts of trouble. Pcs could kick the door in like every other level. Mine used control weather and leveled it with a tornado. Sure, the underground sections were fine, and they went in ahead then rather than pulling any other shenanigans, but that structure was just gone. the creatures that could teleport or were near the way down could get away. The rest were in a tornado. If they had decided to spam earthquake instead they could have leveled the whole thing honestly. And this isn't even the limits of the things they could have pulled.

And thats if they decide to stick to the script at all. They might just decide this is stupid. Let's go to the plane of earth now. And off they go. Maybe they decide, let's go become liches and build a moon base in a week. And they probably could. And the gm then has to either decide to go along with it or just go guys this is what I wanna do please stay to it. Because you're at the point that the pcs can craft their own narratives without asking permission.

And thats the crux. Paizo adventures operate on the assumption the pcs have lasted this long in, they're invested to see it through and not go off and do their own things. They cannot account for every possibility a high level caster might pull off. So they are built for those who are willing to or aren't aware they could choose not to play by the adventures assumptions with a few what ifs tossed in for corner cases and fail states, and they leave those who don't to the gms to manage.

Whether one likes this playstyle or not is irrelevant however, the point is that it existed and it wa an option for those who wished to use it. It wasn't quite as good as it could have been perhaps or as well supported overall. The entire thing with Mythic and Wrath of the Righteous is a good example of them sorta wanting it but more so but not really understanding how to do it or work with what they had created. Really the only thing I'd say that pathfinder failed at in regards to epic battles and such is that only casters really get to partake of them and the martials are almost totally reliant on them.