To what degree does the content of a fiction writer's literature reflect their innermost personal dessires?

Does what an author writes reflect their personal preferences or desires?

Examples:

- does a murder mystery reflect some deep-seated desire of an author to kill someone?

- does a romance novel mean that the author is lonely and searching for love?

- does an action novel (say, Lee Child) suggest that the author wants to be a man or woman who gets into fights?

- does an story that involves incest mean that the author wants to be with their sibling?

- does a police/crime procedural (Scarpetta novels, Kellerman novels) mean that the author really want to be a cop?

And so on..

Does the type or genre of literature reflect the inner desires or proclivities of the author?