As someone who has studied the Bible in some depth, spent time studying Qabbalah, and is familiar with Biblical Hebrew... I would agree with your assessment that it is not the "royal we" we see in the Old Testament. Most scholars agree that these stories are older than the Jewish religion, and older than the monotheism which caused people to go back and expunge most talk of multiple deities in the Torah but leaving various names and titles of G*d so as to leave hints for the serious mystic.
This, though, was completely erased from nearly all of the translations of the Bible out of Hebrew. It is pretty much standard that all the names and titles of G*d in the Bible be translated to the terms lord & G*d with occasional titles like "father who art in Heaven" or "King of the World" surviving the purge. As, of course, do some words that indicate gods and demigods that are clearly not "G*d" make it into many translations untranslated. (the various Baal characters, nephilim, sons of anak, anakim, sons of G*d, giants etc.)
In order to understand all this properly, you must keep certain key facts in mind.
1) Abraham was a Sumerian from Ur.
2) His father was an idolmaker and high priest.
3) He was therefore well versed in Sumerian "mythology"
3) Nearly all of Genesis is a "cliff notes" retelling of Sumerian creation and historical tales.
Place any story from Genesis next to the old Sumerian cuneiform tablets, and you will find that they are clearly summarized versions of the later. This includes everything from the Garden of Eden (E-din in Sumerian) to the Great Flood and the building of the Ark. It includes the whole Anakim, Nephilim, giants and all the rest. It is probable that the terms Anakim and Elohim are referring to the Sumerian Annunaki.
If you look at the Sumerian version of the Garden of Eden story, it is not a single deity talking to himself like a schizophrenic... but rather two or more gods at different parts. Our modern Jehovah is actually cobbled together from the two main Sumerian leader gods Enki and Enlil... with elements of a universal and transcendent "One G*d" tacked on later due to the revelations of the prophets.
The reason he seems so schizo in the Bible is that for much of the Sumerian tales, these two half-brothers and their descendants were at war with each other. Enlil (literally lord of the command or hosts) was the original "king in heaven" because he ruled on the homeworld. Enki (literally lord of the Earth) was the chief scientist (symbol of two snakes twining like a DNA double helix) and the actual creator of humanity. Despite being older (and seemingly wiser) than his younger half-brother, he lost the birthright of Kingship of the gods due to his mother being not the Queen.
At any rate, Sumerian mythology is vast and fascinating. It reads like sci-fi with clear depictions of spaceships, launch sites, wars with weapons of mass destruction and more. It describes a plausible creation story for humanity and describes the gifting to humanity of all the technology and science which historians to this day acknowledge were first displayed in Sumer. Of course, one must remember that the Sumerians had no practice of fiction. They did not make up stories for fun as far as we know. Nor did they think what they wrote to be mythology. They believed they were describing history and the world as they understood it to be. They believed these stories to be fact... as best as they could explain it.
Anyway, just thought I would throw that in there.