I could care less about MODs. Honestly, MODs just annoy the crap out of me for the most part.
What I would love to see are some DLC Campaigns and yes I would pay to download some if they were as long as the HW1/2 Campaigns and just as detailed. You have no idea how excited I would be to see announcements when I fire up HW:R that there is a new DLC available.
So please, someone start making DLC Campaigns that use the default HW:R engine without any tweaks or adjustments.