Jonathan Franzen's book, The Corrections, contains some very vivid scenes & chapters through the eyes of a man suffering from dementia -- I can't speak to their accuracy, but they are very powerful.
The same developer who made Dear Ester previously made a HL2 mod that takes the player through delusions of someone suffering from Korsakoff's Syndrome