If anyone is interested I managed to complete the survivor campaign even with the bugs and without using any of the cheat codes available. Now working on Series 9 play through.

I'm on win 7 64bit.

Below is the list of issues I had and how I managed to fix them/work around.

Bug: Black screen when mission loaded.
Fix: Turned on win 98 compatibility mode with admin seems to fix the issue.

Bug: Mission failed as soon as it was loaded.
Fix: Turned on win 98 compatibility mode with admin seems to fix the issue.

Bug: Missions crashing randomly throughout game play
Workaround: Constantly save your game and if need be save over an old save of the same mission then reopen

Bug: Units capped not producing.
Never encountered this one. But I do remember in the original CD version that certain missions were unit capped