In his new memoir, the J. Geils Band frontman tells a wild tale of recording with Franklin in his never-a-dull-moment life