The biggest problem Paizo's setting has is that every official adventure is canon. This creates a huge problem where every major region has already had it's problems solved, so they have to retcon like a super hero comic to keep things interesting..
Yes, I never understand this approach. Games are only as organic as they are in individual sessions. If I'm not mistaken, it's been a while, the last few Adventure Paths offer some agency in terms of the key decisions can choose to make, but the subsequent modules go for a decision determined by the authors, thus requiring any DM to do a lot of homebrewing if they wanted to keep playing the next AP.
They even do this within an AP.
For example, Return of the Runelords, there is an option to keep Xanderghul alive, by accepting his surrender. Personally, I'd take that route, because one of the most powerful ancient runelords, one that manages to become a demigod, alive to meddle in the present day seems far more interesting than that fat jealous hag Belimarius. The very next chapter, however, assumes outright you kill Xanderghul and you somehow will never, ever kill Belimarius. So in the end, the two Runelords that survive are the two surviving women. One is a tyrannical seductress-sorceress with insanely high CHA score, and yet adventurers are assumed to instantly trust her instead of asking whether she is doing some charm-thing on them. The other one... ah who knows.
The Lost Omens 2e lore all follow this. Whatever decisions you made in a certain AP that don't agree with what these people want to be canon - who cares, negated by lore.
These people should go write a novel if they want to railroad players like this. Oh right, the Pathfinder novel line folded. My bad.
Edited to add: I forgot the worst. Their last 1e AP line required players to sacrifice their characters FOREVER, unless they do some contrived stuff first, to supposedly destroy the big bad Tar-Barphon. Oh, you killed him? Open the Lost Omens campaign setting and weep, losers, because he didn't get killed, just... went on a holiday. Ha, ha!
Compare this to the 3.5e D&D splatbook Elder Evils that allows players to sacrifice their characters to save the world from Atropus the Undead Planet of Doom. That is a much better sendoff one can give the players to celebrate the end of an edition!