C&C4 was the game that ruined it for me. Then Rivals came along and made things worse with all the microtransaction crap.
If the remasters turn out to be as good as the information so far suggests they will be, I will be very happy and will definitely be adding them to my collection.
As for playing the older games on modern OSs, I have The Ultimate Collection on Origin and all the games worked just fine on Windows 7 last time I tried them (including the originals). And there are options for playing a few of the games that improve them beyond the originals in terms of compatibility etc (e.g. the Tiberian Technologies patch for C&C Renegade of which I am the lead developer)