I've been playing Lord of the Rings, Battle for Middle Earth lately (I believe the game came out in 2004?). Anyways, the small pool of players isn't as fun as you remember. The greentext notes giving up based on team matchup, and oh boi is that a big problem.
I really wish BFME2 could get a remaster in the fashion of the Age of Empires Definitive Editions. I only ever played single player back in the day but I'd love to be able to easily install it and play some multiplayer games.
The problem for me is with the size of the player base though. Without a large enough community, it's hard for a complete noob (which I am—as a kid I only ever played BFME2 against AI, almost exclusively siege maps, and at low difficulties) to enter and find a game at roughly their level. A remaster with a matchmaking queue is exactly what I needed to get into competitive Age of Empires/Mythology (where I'm a little better as I at least understand the basics of how to build an economy/what decent build orders are) and I would probably need something like that to get back into BFME for anything other than play with friends.