If you're getting this game, then go straight to the expansion Kane's Wrath instead.
This base game is okay, but there's one big reason for the dislike: If you play the campaign up to a certain point where it's easy to get stuck, and then dig up the history of this game online, you'll see that EA was trying to get into the competitive e-sports with this game (and RA3) but they were simply blinded by greed and wanted to hop onto the bandwagon to make a cashgrab and didn't know what they were doing (in terms of mechanics and feel) so they screwed up the campaign balance in a patch meant to "balance multiplayer", and have never fixed it. More specifically, you're supposed to have way more income in the campaign than you currently have.
imo the C&C/Westwood-style RTS just isn't built for e-sports in general, and that should be ok! Compared to say StarCraft, C&C3:TW has only one resource (other than time and location) to manage (tiberium ("money"), in contrast to minerals and vespene) and has units that are way more overspecialised and gimmicky. For example, your construction yard will always be one of your huge weak spots - it's tanky, but some siege units don't care much, and there's also engineers. Also, one of the main competitive multiplayer strats I read about was selling your MCV to sink more cash into an all-in rush. This whole formula suits a casual "I just wanna have fun with weird units and destroy stuff" player more.
The next most major complaint I'd have is how clunky the game - specifically the units - feels. Sometimes they would stall for whole seconds trying to inch forward before firing or garrisoning, while the enemy continues to take free shots at them, thus losing an otherwise easily winnable battle. The pathfinding also tends to disappoint - I randomly find the units that I sent a long way away to be strewn all across the battlefield, maybe because their main target has been destroyed.
Kane's Wrath's campaign on the other hand is quite playable, and enjoyable, although it does reference the base game's campaign. The expansion also introduces new subfactions and units that really make the whole game have more enjoyable destruction overall. It does still inherit some flaws of the base game, but those flaws seem more tolerable when there's fun.
P.S. The main reason I got this game is because it's my first entry into the Tiberium universe. I've only played RA2/3 and Generals before this. The Tiberium universe seems to get the short end of the stick because it's the prototype for the next Red Alert game, which comes 1-2 years later and is a tad more polished. (This game is a precursor to RA3, and C&C2:TS was a precursor to RA2.)
Compared to these other games, C&C3:TW also seems to focus on commander-level abilities a fair bit, which I'm not a fan of as they cost money and seem only worthwhile in certain tactical scenarios. EA probably had in mind for elite players to make clutch ability calls, but it's not really succeeding.