I currently have LOTR Battle for Middle Earth and although I've yet to play campaign yet, I have played Skirmish and online and it is a pretty cool game but is way too simplistic and slow-paced for me.
It takes hours just to finish a match, and there isn't really much skill needed besides the normal "Build an army and attack" gameplay.
Still, it is decent for a movie-to-game conversion, so I would definetely say that anybody who is a LOTR fan and who enjoys RTS games should give this one a look.