Forget the Bible, there’s too much discussion of Adam and Eve in midrashic sources to believe that it’s all fabricated and that they were not historical people. The “Book of Adam and Eve” can probably be found on the web.
I agree, revelation suggests rather strongly that Adam and Eve were historical individuals.
Not sure when we can place them within the archaeological and paleontological record, but it’s best when we are not sure of something to simply admit we’re not sure and keep trying to find out, rather than forcing bad conclusions in either the science or theology.