"In this series of fourteen endgame books, FIDE Senior Trainer Adrian Mikhal-chishin, FIDE Trainer Efstratios Grivas and IGM Csaba Balogh combine their experience as trainers and as practical players ... The main concept of each book [in The Modern Endgame Manual series] is to provide theoretical knowledge which can be used in practical games. ..."
https://www.newinchess.com/media/wysiwyg/product_pdf/7627.pdf
Damn! 14 books! That alone is going to bankrupt me for sure. But if you bring it up then it must be worth it while.
My guess is that the books are not worthwhile for someone who is not a very serious chess player. However, you did write: "... The more comprehensive the book the better. …" Consequently, I thought I would try to give you some idea about what happens if "comprehensive" becomes the number one priority. By the way, the quote is from the "Editorial Preface" in the first book.
Good point. And point well taken.
... 100 Endgames You Must Know, by Jesus de la Villa, ...
"... the 2000+ player for which 100 Endgames You Must Know is really intended ..." - Steve Goldberg
https://web.archive.org/web/20140708105702/http://www.chesscafe.com/text/review645.pdf
"... Players from 2000 up to International Master will find 100 ENDGAMES YOU MUST KNOW quite useful." - IM John Donaldson
http://www.jeremysilman.com/shop/pc/100-Endgames-You-Must-Know-78p3863.htm
https://www.newinchess.com/media/wysiwyg/product_pdf/9026.pdf