I've played the Red Alert 2 campaigns more times than I can count. The campaigns for Tiberian Sun, Generals, and Tiberium Wars are also all amazing, which makes it hard for me to pick a favourite or the objective best.
all mentioned issues here are easily solved by using aoe2tools (both compaigns and offline mods (not just pussywood but any visual mod you can think of )