I know I'm late on this topic but I wish to testify that if I played the offline campaign early on it was to get the unlock weapons to play online, and it was feeling like work for me, not fun. I enjoyed somewhat the RoF campaign (the biography part, in fact) but the world is too sterile for real fun in RoF, even with PWCG
I actually enjoyed a few dynamic campaigns in my sim days, Falcon IV, Strike fighters (europe,vietnam,iceland,modded falklands), OFF, EAW.
About static campaigns, I enjoyed playing various Lomac, and so many IL2 I can't count them.
Now Jason thanks for "making things possible" and let the flight sim production go on, but if you ever work with russians again, please ensure that you're the boss, that they produce a decent offline content with a career, and an easy to use FMB that can be used to create careers, and finally that the game can handle significant AI numbers so the world is less sterile, both in air, on ground and on the radio. It's really pitiful that 2010+ sims are vastly inferior to their 1999 counterparts on the "being there" part, bar FM fidelity and nicer graphics.