Welcome, Hyrstx.
I recommend you get EAW for the single-player campaign. The AI in Community Edition is frankly wonky. (The best AI is found in the original SFC, which has a good campaign too.) After a hundred hours of research (or a lucky break) I might possibly be able to modify the AI so that it stops choosing to capture everything!
The current purpose of Community Edition, in my opinion, is to provide excellent multiplayer skirmishes for players using Windows XP, Vista, 7, 8, or 10. It does this quite well.
BTW, not everyone who does multiplayer is an ace. You'll find players who are either very rusty or are new to the game. d4v1ks, XconGeneral, and I will be helpful.