Reading yours and others comments it seems that I should take a look at the 3rd film at least.
The 4th film sounds worth avoiding and then the latest back on track again.
I intend to get the latest book but will probably leave the films until my little boy is old enough to take an interest in them. Then, hopefully, even the worst of the film series will take on a new light as I see them through his eyes to some extent.