I agree with that, I either want huge armies that need to be micro'ed less, or small armies that you have more control over.

For huge armies, Look at Shogun or Medieval: Total War. Both put an incredible number of units on the map at once, but are still pretty easy to control.