I think most of the Moist Discworld books fit this description. And the latest Watch/Vimes book, too - Snuff (maybe The Fifth Elephant and Jingo?). Although with Vimes it's less, "here's a shitty situation, you're in charge!" and more stumbling into it when you're out of your comfort zone.