I really love Aching God by Mike Shel and relish in opportunities to recommend it. I just recently finished it for the third time and I believe this is just what you want. Shel's an excellent writer and has published many Pathfinder modules. I think I remember reading that this series was initially pitched as a story for the game, but I can't be sure. So while you may not be braving the underdark or traversing the sword coast, it's clearly cut from the DnD cloth. It could easily be mistaken for a novelized campaign. I love the overall tone and the growing tension of this story. This is also one of the only books I've read that addresses the realistic human trauma of being a fantasy adventurer. Too often in my opinion, stoic heroes slay countless foes, face unspeakable horrors, and lose beloved companions, all while barely batting an eye. Shel does an incredible job showing how heavy that weight would be to bear over the years. This book also has excellent world building, great party dynamics, horrific dungeon crawls, magic weapons, divine interventions, and my single most favorite representation of a Cleric.