Along with soundtrack to Diablo II, The Fellowship of the Ring got a lot of play time at my tabletop, especially when I ran the Forge of Fury adventure. But unlike Diablo II (and most other movie scores) you shouldn’t just let it play during your game. You need to queue up the tracks for important scenes.
For example, playing “Concerning Hobbits” during a fight scene probably won’t go over well, but part of “Flight to the Ford” would–especially if your characters are fighting a dragon or a Nazgul.
Good combat or chase music includes: “A Knife in the Dark,” part of “Flight to the Ford,” Part of “A Journey in the Dark,” “The Bridge of Kazahd Dum” (of course–well until the end after Gandalf dies–but that part would be perfect if a character dies or there’s a Total Party Kill.)”
The rest of the tracks? Mood music. It just depends on what you want to do with it.
Keep in mind, however, this music is high fantasy. It works well with a “standard” D&D game, for example, set in the Forgotten Realms. Not so much with “grimdark” campaigns or with the tones set forth by games like Dungeon Crawl Classics RPG.
The only downside, perhaps, to this soundtrack is that players might be too familiar with it. It’d be kind of like playing music from Star Wars. Which is fine, but then you’ll get everybody thinking about Star Wars.
Something like this might occur here, with your players quoting “One does not simply walk into Mordor” or “You shall not pass!” Leitmotifs can do that.
I can also attest that The Fellowship of the Ring is a great soundtrack to listen to while painting miniatures.
Get this if: You want a good rousing musical score for your fantasy RPGs. You want to round-out your movie soundtrack collection.
Don’t get this if: Well, I really don’t know why you wouldn’t. Even if you don’t intend on playing it for your games, it’s still great listening.
There’s a “Complete Recordings” version floating around out there, which I don’t have, but am envious of those who do.