Mitnick's "Art of Deception" springs to mind. Sort of a combination cautionary tale, autobiography of what can go wrong, and workbook for techniques. And an indicator that the California DMV is still vulnerable, decades later.
"Social Engineering: The Art of Human Hacking" by Hadnagy.