Its a pretty decent singleplayer game, but the AI is pretty retarded.
The Desert Combat mod is free, and it makes the AI a lot smarter, as well as adding tons of maps, new guns, and all kinds of vehicles.
You generally have to download Desert Combat, which could be a problem for you. Over at fileplanet.com you can add it it a CD and have them send it to you, but I think that might cost you some money.
Since you're a helicopter pilot, I think you would really enjoy flying the new helicopters