I enjoyed The Somnambulist, a novel about a magician who freelances as a private investigator in Victorian times. His assistant (whose name gives the book its title) may or may not be supernatural.
There's not a ton of magic per se, but it was cool to find our trade in pop-fiction.
For more fraternity-directed books that you can readily find - Tricks of the Mind by Derren Brown is excellent, Designing Miracles and Strong Magic by Darwin Ortiz are worth reading, Shattering Illusions by Jamy Ian Swiss, Fitzkee's books (I've read The Trick Brain, and plan to continue with the others).
Also, look to magicians who've peppered their books with theory, like Tommy Wonder or Rene Levand or John Carney. You can learn a lot by seeing theory in application from these greats.
Pj