Is there a book, or series of books, that acts as a comprehensive history of the Napoleanic and Revolutionary Wars? If so, is it any good?
There isn't any good ones that are comprehensive outside of Chandler's Campaigns of Napoleon which is out of print and hard to find. Look at this book list that I put together for the sub.
The one thing that the Napoleonic and French Revolutionary Wars are noted for is the wealth of personal diaries the solidiers wrote and has been kept and handed down. They include both infantry and calvary men and officers, for the most part, from both French and her allies as well as her belligerents.
http://www.napoleon-series.org/ - attend to their 'research' section for a lot of reading material.