The very best one was the Desert Combat mod for the original game.

I remember sitting in Business Law class in the back flying a chopper with a trackpad, mowing down dudes in the Battle of the Bulge or whatever.