Thank you for pointing me towards Dynamic Recon Ops and Dynamic Combat Ops.
I have tried it recently and it's really good. I'm not to much of a multiplayer so these kind of content suits me the most.
I can also recommend HUNTER SIX - Special Operations Unit and Resist Campaign.
The first one is sort of a sandbox minicampaign and the second one is scripted mini campaign which is so well made it feels like an official DLC.
DUWS is great but seems to be abandoned by the author and broken by ARMA III patches since it's release, but there's similar ARMA Commander mod avalaible in the workshop.