In civrev, units can be invisible too, but I've only seen this on multiplayer in games that are really buggy to begin with. It's not every unit, and usually the unit has to die before becoming invisible, then they can move around and actually take cities, it's weird.
he must be talking about PC Civ though, never heard of this problem for the console.