Here are a few review papers I could dig up in a couple of minutes:
2019: https://juniperpublishers.com/pmcij/PMCIJ.MS.ID.555601.php
2017: https://sciendo.com/article/10.1515/cpp-2017-0003
2011: https://pubmed.ncbi.nlm.nih.gov/21764150/
2009: https://pubmed.ncbi.nlm.nih.gov/20010032/ (with focus on dementia)
Scientific American blog post: https://blogs.scientificamerican.com/bering-in-mind/one-last...
However, she did have a moment a few months before where her symptoms seemed to completely vanished for a couple hours after a doctor flushed out her Alzheimer's meds. Unfortunately I was not there, but my mom said she was suddenly completely attentive and remembered everything like her old self during that time. I don't know if it was coincidence, related to the meds, or if the flushing process did something (I'm told it was intense). I wouldn't be surprised if other patients have experienced similar things, but I don't think it's related to death.
It was bizarre interacting with him during this lucidity. He was able to do most physical things without assistance (he still had a bad hip) and you could engage with him in conversation. He knew who I was without prompting, something he hadn’t been able to do for about 4 years. He knew all his children and grandchildren. He also shared stories from his middle years, something he had stopped doing during the early stages.
It wore off though, in about a week or so he began to have the brain fog set in. His doctor was also not too happy to hear about the withdrawal.
The only person who seemed disturbed and worried about this moment of lucidity was his caretaker, who had worked with dozens of elderly folks with memory issues prior. She said it almost always happened before a sudden decline. She was right, about 3 weeks later he became very ill and then died within a few months.
For instance the sister for a famous (for the state) news reporter would seem to come out of it a bit to talk about her sister, but mostly she just walked along the walls, tracking the trim with her fingers and mumbling to herself.
It is a nice myth to pull at your heart strings