Halo Wars is RTS lite IMO. It's not a bad console RTS but you're limited to two races (online) and only play as humans during story mode. The single player mode lasts 8-10 hours (15 missions ).
As for KDR's problem, you can select seperate groups with the right trigger. Copied from website:
"Right Trigger
While commanding entire platoons is great for troop movement, it's important to have access to unit-specific commands when the bullets start to fly. In Halo Wars, the Right Trigger is used to cycle through your individual units without sacrificing control of your army.
For instance, let's say your army clashes with a widely varied enemy force. Units must be ordered to attack enemies that they're strongest against. Quick use of the Right Trigger will have your Warthogs running over Grunts, your Flamethrower squads engaging Hunters, your Spartans jacking enemy vehicles, and your anti-air Wolverines blasting Covenant Banshees out of the sky.
Once you're done issuing unit-specific commands, tap B to regain full control of your entire army.
"
So you can actually get your units to attack a certain way but my grip was with ai's pathfinding abilty and no army formation. I tried to get them in somewhat of a formation by manual control but as soon as an emeny appears they scatter

.
Still for console owners Halo Wars isn't to bad but still flawed IMO. Civ Rev is still the console RTS to beat.