I've been researching Lillith for about 20 years.
She has always intrigued me because based on 2400 years of tradition, she is the very first woman...and the very first ex-wife and the first "spurned" creature in all of creation. That is a pretty powerful position to find one self in...Can you imagine. You know G*D intimately...you were just created, and within a short period of time, because ONE GUY thinks you are too independent, you are literally, thrown out of the world... Sheesh. Talk about having issues.
Remember, Lucifer wasn't spurned.. Lucifer rebelled. The fallen, all of the angels that followed Lucifer, they weren't turned away, they left...the Nephelim, the titans, so many things... Lillith was the first thinking, feeling, being, whom G*D looked at and said, My buddy don't like you...get lost!!!
She is a fascinating facet just from a purely Sociological standpoint, let alone a humanist, and humane standpoint.
There are so many stories.. I am going to completely ignore the Sumerian, and Akkadian version...It is much more likely that the creatures discussed in those stories were a Species, and not an individual.
Now purely for the individual known as "Lillith", the greatest reference is still the Talmud.
If you don't know the Talmud, isn't like the bible. The Talmud isn't the "cliff's notes" of the original bible...some people think the Talmud is the short version....
Really the Talmud is more like watching a movie, with the directors commentary turned on. That is what the Talmud is. It is thousands of years of oral tradition ABOUT the specific components and passages of the Torah...the original bible.
Now this is also deferring the concept of the Androgyne...Even if that version was literal, then Lillith was still given her own body and was replaced by Eve. So No Buenos.
I'm also discounting the entirety of the Kabbalah. Lillith was just a justifying vehicle for male dominance in that system.
Now lets walk it backwards : 17'th century, she's eating peoples babies and making men unfaithful in their sleep and she is a "queen" of demons and in absence of heavens grace will she dwell for ever.
12'th century Lillith left the Garden of Eden and made her own kingdom, a kingdom of monsters..she is the mother of monsters and she is cursed by G*D to rule a dead land and have no effect on the world and this she is punished to do , so when Cain slew Able, she was waiting for him when he was cast out, and she helped teach him how to raise a new nation and to become his consort and mentor...so her curse is forever.
5'th century Lillith was the first wife, and she when she was replaced, by a more appropriate helper she went off quietly and lived alone in exile... Forever.
2nd Century BC Lillith is punished by god to give birth to a 1000 offspring each night, knowing that all of them will die during the day... Her punishment is to LOSE...everything...over and over and over...forever.
The Torah originally says that Lillith is made from the same clay, at the same time, so Adam and Lillith are equals. So she will not "submit" to him, on his terms alone. So Adams god banishes her and she is forced to make her own kingdom and she rules over beasts and monsters and Adams god sends mating pairs of birds and animals to taunt her....so that she can see that all of these simple creatures have a mate...and she does not....FOREVER.
Adams god decides that she needs to have it thrown in her face, every moment of every day, forever...because sometimes..she wanted to be on top LOL..
Another version says that she went out and created her own kingdom and then G*D smote that kingdom and laid it to ruin and so on.
Here is the one thing that is consistent. G*D condemned Lillith to whatever punishment or banishment...forever! This goes so far beyond the realm of other things, it's almost certainly an oversight just continuously repeated, and never considered.
If you really look at the Talmud, and Torah, nothing is forever except for the kingdom of heaven itself...and Lillith.
Is she a goddess? In as much as one religion states that she was the owner of the very first vagina in all human history... I'd say yes. That makes her a goddess.
Is she a demon? Well..consider the source. The people who decided she was a demon, were the ones who decided that "independent" women were so bad, that their god needed to make a new one, as a servant and a helper and a submissive sex toy.
If you want to look at it that way.