I can agree that most of Paizo’s adventure paths can be lackluster. I highly prefer PF2e to 5e, but my favorite adventure paths are the 3 part ones, Stolen Fates, Quest for the Sky King’s Tomb, the 6 part ones definitely feel like they’re stretching a plot to reach 6 parts and should have broken it into separate stories or fewer books.