I really like adventure books if they are done well and give the players some opportunity for development. My active player days are in the past though. Still like to browse through adventures for some reason 😅 One of my favourites I know is the first part of the "Serpent`s Skull" adventure path, "Souls for Smuggler's Shiv" for Pathfinder (the old version derived from D&D 3.5). The players are shipwrecked together with a couple of NPCs on a dangerous island and have to build a camp to survive and find the person who was responsible for all this.
I don't know much about Pathfinder's adventure paths, to be honest. But I will check that one.