I find Lord of the Rings Online to have some of the best story driven questing. The story line is interesting, the quests are fairly varied and the 'ohh...' factor when you walk into well known places like Moria is awesome!
I played LOTR Online when it first came out! I think the only MMO I've paid for. Sadly, I don't think I was as much as fan of it as you were, I bounced off it by lv25. Probably much has been added in the last 10+ years though!
I have just started playing LOTR Online a few days ago after getting completely burnt out in WoW, and I'm finding it to be much more fun than I was expecting. The game engine is a bit less slick than WoWs, as it clearly has not been as updated as often as WoWs has been, but the environments and heavy story based questing more than make up for it.
I thought the Mines of Moria was the most atmospheric zone I've seen in an MMO. Really captured the creepy, ancient ruins feeling...Oh! Give monster play a try! Its a rather unique take on PVP where you can actually play as the heroes or the monsters!