Yes.
You keep saying that. You should stop saying that.
And ............ again, two parts does not cover the whole.
Now, regarding the CCC passages: After reading the relevant passages (beyond what Mr Polo has posted), I have had to modify my own position somewhat, but not too much. I have never objected that God is the source and ultimate approver of what is in the Bible, but I do object to the way you are using the word author. Another relevant passage from the CCC, cited from Dei Verbum, is:
"106 God inspired the human authors of the sacred books. "To compose the sacred books, God chose certain men who, all the while he employed them in this task, made full use of their own faculties and powers so that, though he acted in them and by them, it was as true authors that they consigned to writing whatever he wanted written, and no more.""
The CCC is affirming that God is the "true" author of the Scriptures, but it is not diminishing the role of the writers themselves, which is the vibe your analogies are giving me. It has a more direct view of what constitutes divine inspiration, but other than that my position was fairly close to it to begin with.
It's just that when I hear/read "God wrote the Bible," it conjures up images of human copy machines. Analogies about secretarial dictation or humans as pens don't help.
I think because of these CCC passages, we are more or less in agreement. Do you agree with the bolded parts of this statement? "God chose certain men who, all the while he employed them in this task, made full use of their own faculties and powers so that, though he acted in them and by them, it was as true authors [...]"