I've found the census (and other official records) to be disorienting, but that could've been because my family immigrated to England and there was little consistency with documented names. I remember my younger sister changing her name, so when I found a family of four (with an older son born the right year, with the right name -- no small feat! Early 20th C. Russian Jewish immigrant families NEVER had only two children!

) where the younger sister ultimately Anglicized her name, it was a huge hit. However, last names were changed in later records (possibly for pronunciation purposes?) and there was at least one other almost identical family that COULDN'T have been mine for various reasons -- but they had incorrect birthdays and other details. And these two families seemed to leap frog one another -- one would exist on one document, the other on the next, creating a weird, suspicious paradox that left me feeling kinda hopeless about the whole thing.
I also tried to find my partner, who may be listed among the (mostly unlisted) victims of the Lancastria sinking. He was a native Brit, and even HIS name was un-trace-able! People with his name disappeared and reappeared in the documents at random. My (current-life) husband is super into research and accuracy and such -- I gave up looking LONG before he did. Ultimately, he only made himself frustrated.
Personally, I ended up more confused and troubled than before I even looked. I couldn't follow one single person from birth to death. Very confusing stuff. There were certainly enough synchronicities to peak my interest, but I'm easily discouraged, and it ultimately felt more invalidating than confirming. And I mean that broadly -- seemingly EVERYONE WHO EVER LIVED was invalidated! What I learned from these records is that, if it's proof you need, nothing ever existed! Sure, someone may exist in 1921, but where are they later? And then when they reappear, will they EVEN HAVE THE SAME LAST NAME?? Is it even THEM? And if not, where did the other one GO? And who is THIS?! It's crazy to have an identity crisis about a life you're not even living
It does bring me a little comfort to recognize that there aren't even consistent records of my own family in THIS life -- people I KNOW existed, have heard stories about and seen photos of. Who knows why, but they don't enjoy much recorded consistency either. Honestly, I'd be hard pressed to "prove" my great grandparents existed using official documents!
For now I'm just sticking with my memories. They're very clear and very stable, whereas "concrete" reality is apparently a chaotic illusion