I will say Lord of the Rings: War in the North is one of the best co-op experiences I've ever had

And the KotOR games are some of the best role-playing experiences I've ever had

But I don't think either of those are in the spirit of this thread. They're based on a mythology, not really based directly on a specific movie. They both took the mythos and carved out their own path. Rather successfullly, too

On that note, Baldur's Gate is a D&D lisenced series

And also on that note, the Forgotten Realms: Demon Stone game was pretty stellar for a random action game. Not a bad story