Regarding the campaign though - the last decent one was the first OFP. And maybe that was just because of the huge WOW factor of the game itself (at least for me), so the SP felt more special. But I still recall it as a bright light. I think it's hard to make a proper campaign because everything is so random and if you want things to happen in a certain way it's incredibly hard to achieve that other than using area markers for "everyone dead"
Time to remake my old coop mission from Ofp to Arma 3 now, should be fun.