Command and conquer the first decade

[judicators]

Hello people 
I recently found my physical copy of "Command & Conquer the first decade" in the blue box and i would replay all the campaigns and possibly some multiplayer again for Tiberiun sun and up since i already own the C&C remaster on steam 
Last time i played it must have been 5 years ago and i had to install an unofficial patch to get it to work on Windows 7
So my question is:
Is there 1 patch that makes it all work flawlessly (Im on windows 10) or do i have to manually install a patch for each game ?
https://cncnet.org/command-and-conquer#download
https://cncnet.org/red-alert-2#download
And so forth

And do theese patches work for singleplayer / skirmish aswell or is it stritcly multiplayer ?? Im kinda confused

And seeing as im mostly here for the Red Alert 2 games are there any good mods you guys would recommend before i start playing the campaigns again ?
I play alot of Brood War custom campaigns aswell, is there somewhere where i can find a list of all avaivable campaigns 
I was thinking something in the line of this Brood War spreadsheet https://docs.google.com/spreadsheets/d/1l_ink-CKwo92syCxJmivfh7zeMZu4U0p_q5Ra7HTF4U/edit#gid=0

Ty for you time

Cheers