Perhaps the best option to understand thoroughly is the book "From neuron to brain". This is a rather difficult book, but there are very detailed and clearly analyzed issues from the transmission of signals between neurons to the formation of cognitive functions. From a simpler: - Ramachandran (The brain talks) - Frith (The brain and soul) - Seung (Connectome) - Doidge (Neuroplasticity)
I also advise (I don’t remember the author) "Revolution in the brain", this is about neurogenesis.
In addition to the above, I advise Crete Frith "Brain and Soul", Dick Swab "We are our brain. From the uterus to Alzheimer", and of course the books by Oliver Sachs.
I would also highly recommend the books of Vileyanur Ramachandran, professor of psychology and neurophysiology at the University of Caliphronia, one of the leading specialists in neurophysiology.
He writes about the structure of the brain and how the malfunction of its individual blocks or connections between them manifests itself in various psychiatric diseases and deviations.
Two of his books have already been published in Russia: "The Birth of Mind" and "The Brain Tells".
Rita Carter "How the brain works".
I would also recommend listening to a series of lectures by Vyacheslav Dubynin in the Popular Lecture Hall (from Popular Mechanics magazine). All lecture titles begin with the word "brain", for example, "Brain and Memory", "Brain: Thinking and Will", etc. They can be easily found on youtube and other similar services.
Asya Kazantseva's book is certainly more cheerful and perky, but at the same time, in my opinion, more superficial than the above sources.
Also interesting are the lectures of Olga Svarnik, for example this one: postnauka.ru
The first thing that comes to mind is last year's bestseller by Asya Kazantseva "Who would have thought? How the brain makes us do stupid things." Scientific credibility and fun under one cover - this kind of mix is not often found.