There are many types of RTS games. All have good, and bad points in them. It all depends on what genre you like, and how you like to play.
The "Fast Paced" RTS. The CnC/Red Alert series started it. The Warcraft/Starcraft series built upon it. Basically the games boil down to a non stop frantic micromanaging click fest by end game. The DoW 1/Company of Heroes series comes very close to this as well, because they are very similar game play wise to Starcraft. Many enjoy this type of game play, but i personally do not (with the exceptions of DoW 1, and CoH).
The Normal , or "casual" RTS. This is more my cup of tea. Games like Sup Com, Total Annihilation, Homeworld/Cat/HW2, Earth 2150, etc. fall into this category. (So can DoW 1, and CoH depending on how you play them). These types are more for the casual gamer that enjoys taking their time to think about what they do before they do it. They can turn into click fests, but that all depends on the play style of the gamer more than the game itself.
The "Chess Game" style of RTS. This is the game where you have time to THINK about what you are doing, and what you will do next. Sins in a way is the pioneer of this category. Game play is more about "Grand Strategy" than Tactics. Some 4X titles could have fit in here if they were not turn based like SoTS and Total War, but they are not. They are in the turn based 4X category. Sins is the first 4X type game to base the Strategic portion of the game on "Time" instead of constantly clicking on the "end turn" button. The "turns" progress whether you are ready for it, or not! One minute of time represents a single turn in a turn based 4X, and like chess you position your most powerful pieces (units), and build your empire to gain the most advantage. While your opponent does the same. This is the Strategic portion of the game, and it all takes place in real time. Like timed chess if you chose not to move in the time allotted then the turn is forfeited. The battles in the gravity wells are where the tactical portion of the game takes place (queen takes rook, Pawn takes bishop, etc.). That takes up most of the game time.. Once the pieces are in place.. Then BOOM! Checkmate, or in Sins case "Steamroll".