The two that came to my mind, cause I just don't see how they could make a usable live version are...

Robert Asprin's  M.Y.T.H. Inc. series

Piers Anthony's Xanth series

Rumor mill has it that the Xanth series is seriously being looked at for a future film, but, for those that know the books...I'm sorry, there ain't no way they could make a live version and make it good.