instead that very weapon (agent or perhaps the blood of the primordial creator) they stole and tempered with on LV-223 turned against them
Ridley Scott once referred to the Black Goo as "evil bacteriology."
Fire and Stone says the Goo has constantly changing DNA, as if it cannot decide what it is.
So - DNA + "Bacteria" = it could be alive. Viruses are just proteins with shards of DNA, but bacteria are simple single cellular life.
So, the "Gods" could ironically be a form of bacteria or other single celled life that eventually gives rise to more complex life. And the "Gods" are a unique type, perhaps more aware.
Maybe as you mentioned, it didn't just turn on them, it punished them for trying to use it for their own gains rather than the purpose of creating life.
Those are some interesting theories you shared that got me thinking about it a bit. I've always found the Black Goo to be really fascinating and would love to see what else it does.
Remember how Elden became a walking Genesis? Every step he took, plants and trees grew? Amazing! The ship bridge he sat in eventually became an Eden.