Do you think Paul Chapin subverts the trope? I'm not convinced. The end really just plays into all the insinuations of impotence that are made earlier in the book.

The 'I'm going to write you into my next book thing' is hilarious, especially when Archie's head is full of ideas, because later on the series is presented as Archie's published work. So, Archie with his head full of ideas, actually DOES write Wolfe into books, although I'm not sure if Fer-de-Lance or LoFM are meant to be understood that way. The narrative voice in the first few books could be Archie sitting in a bar telling the story to a friend? Early on there are moments like this one (when Archie is speaking to Mrs. Bowen):

I put the pad in my pocket, and said to her, "You might tell me what the question was."
"No, Mr. Goodwin. I think not."
"It might be important. This isn't for publication."

And Awwwwwwwwwwwwww! The whole drugged!Archie segment makes my heart go thud.