If you think X-Com looks better than SE5 you haven't been looking close enough.
Rome can have many thousands of units on-screen because Rome cheats: there are actually at most 160 "units" on screen at a time. The thousands of little soliders don't have any actual bearing on the combat, so you don't have to worry about their position quite as much.
Still a very slick engine, though.