Way back when I was still regularly DMing, I ran most of this adventure path as it was coming out month to month, and it was one of our group's favorite tabletop experiences. Following Burnt Offerings, which flirted with the horror elements, Skinsaw Murders goes full speed ahead in that direction.
Asylums filled with the stark raving mad, farmsteads covered in living scarecrows and the undead, and a serial killer stalking the streets of Sandpoint kick things off. While the adventure as written has the PCs working as deputies to solve the murders, our group went a different route and had the player running Valeros wake up next to the first victim -- having taken to trysting with Ven Vinder's daughter -- and immediately get arrested as the main suspect.
The real goods here though are undoubtedly found in the haunted house segment, which is where Paizo got its start in earnest with using the "haunts as traps" mechanisms that would show up in many future adventures and rulebooks. This is also where the adventurers finally get to leave the sleepy town of Sandpoint and head to the big city of Magnimar.
The Magnimar gazeteer in the back is one of my favorite parts of this issue, bringing up the Hellknights for the first time and offering tons of adventure material. Oddly enough -- perhaps because its a more general overview rather than a building-by-building description like in the previous adventure -- Magnimar oddly feels less cosmopolitan and more homogeneous than the tiny backwater of Sandpoint.
Desna gets a write up here, and while she's one of my least favorite Golarion deities, the fluff here is top notch with the descriptions of various planar allies, wildly different priests, and various myths and relics that have plenty of adventure opportunity.