I am very much an Arma fan, but do find OFP enjoyable as a single player game (MP is totally unplayable for me as I rarely get connection and keep losing sound/requiring reboot) for some short bursts of play, which is also what I 'use' COD4 for. But for more of a thinking, planning game it is Arma all the way, even for setting up trivial missions like flying around trying to go under the spans of bridges, assaulting the aircraft carrier etc..
However, with the CAA1 mod allowing the Arma1 maps to be added to and played in Arma2 this adds another dimension, plus there has been some progress on the BIS forums around the idea of using RAMdisks to speed up the loading of various elements in the game. I have set one up and the 'clunkiness' sometimes referred to I think might be down to the flickering textures and popping up of objects - both are massively reduced in a RAMdisk setup and the game feels much smoother - so worth a try if you have chunk of RAM not being used. Of course, if your hardware is under the required spec it might not help that much . . .
cjph