Find it hard to believe that Desert Combat (the best mod for BF1942 at the time) only barely scrapes in. That was pretty much BF2 before BF2 came out.

50 best mods:

Singleplayer (1-10):
1. Portal prelude
2. The Nameless Mod
3. Eclipse
4. Tamriel Rebuilt
5. Minerva: Metastatis
6. Dear Esther
7. Thief 2x
8. Blue Lotus: total War
9. Maugeter - The Keys To The City
10. Diabolo 3 Warcraft

11 - 20 were all source mods, 21-30 were all tweaks/enhancements for games, 31-40 were Unreal Engine mods.  I can post the modnames if you guys want:

Classics (41-50)
41. Sven Co-op
42. Counterstrike
43. Team Fortress
44. Day of Defeat
45. Garry's mod 9
46. Capture The Flag
47.Natural Selection
48. Defense of the Anchients
49. Desert Combat (<-- Only Battlefield mod in the list)
50. Action Quake 2

Wasn't much of a list, imo, wasn't really 50 "best", just "10 best in 5 different categories".