I had one Cam Jansen book as a kid and REALLY LOVED IT, I think because it had that sort of humor where the author invites the kid reader to join him in eye-rolling at the follies of the adults. (also, Rum Raisin and Lemon ice cream!) They've started putting out new ones in the last ten years or so, though, and those are way more sincere and not nearly as good, based on the one I picked up at work. (I can't imagine them working for a movie, though. There wasn't a *whole lot* there.)

I also have read other Cushman and Korman and Three investigators and like them! (A lot of the ones on this list are ones I own due to residual fondness but never finished the series, actually.) I have no memories of Adrian Mole, though, and don't quite remember why I picked it up, unless somebody was recommending it on DW.