I've played Resurgence and Re-Engagements, Rydenrack, APRA2, Flipped Missions, and Mental Omega.
Are there other mission map packs or mods with campaigns you know?

Both modded and vanilla will do. Though not the ones where it's the vanilla missions converted for the mod.
I most likely played those mods already like RA20xx and RotE. Also prefer if it were a Yuri campaign,
but I know those are rare and was kind of in demand with Yuri's Revenge not having one.

Expecting lots of mods having their own original campaigns soon, like from Project Phantom.
So I'd like to play any type of mission maps/campaign while I wait. Also would be motivational to work for my own.