See, but the characters I'm think of aren't Holmes and Bourne. If anything the Holmes stories have a simple writer's avatar in the form of Watson, who is also a doctor and was amazed by the friend who inspired Holmes

No, I'm thinking of Spencer, who is a perfected version of Robert B. Parker, or Temperance Brennan, who lives in a perfect version of Kathy Reichs's life. That's just sighting two examples. Neither of them take down big villains in explosive climaxes, but they both live in a world that works in their favor to the point of being fantastic.